动态添加数据库字段

Published by admin on 06月 17, 2011

if not exists(select name from syscolumns where id=object_id(’表名’) and name=’字段名’)

alter table 表名 add 字段名 Nchar(100)