--exec add_column 'net_code','dddr',''
create proc add_column
@table varchar(100),--表名
@columns varchar(100),--字段名
@type varchar(100)--数据类型(如不设置,默认为varchar(100))
as
declare @sql varchar(3000),@type_code varchar(100)
if @type=''
begin
set @type_code='varchar(100)'
end
set @sql='if NOT EXISTS (select a.Name as columnName
from syscolumns as a , sysobjects as b where a.ID=b.ID
and b.Name='''+@table+'''
and a.name='''+@columns+''')
BEGIN
alter table '+@table+' add '+@columns+' '+@type_code+'
select a.Name as columnName
from syscolumns as a , sysobjects as b where a.ID=b.ID
and b.Name='''+@table+'''
END
ELSE
BEGIN
PRINT ''字段已经存在!''
END '
exec(@sql)
智能更新、添加表中的列
最新推荐文章于 2021-09-03 17:34:59 发布