使用SQL语句给表增加列

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