IF Not Exists(select * from syscolumns where [name]='字段名'
and OBJECTPROPERTY(id,'IsUserTable')=1 and object_name(id)='表名')
begin
Alter Table [表名] add 字段名 nvarchar(50)
end
and OBJECTPROPERTY(id,'IsUserTable')=1 and object_name(id)='表名')
begin
Alter Table [表名] add 字段名 nvarchar(50)
end