新增数据库栏位脚本

IF   NOT EXISTS(
SELECT * FROM SYSCOLUMNS
WHERE ID=OBJECT_ID(N'MNDIndicator') AND NAME=N'checkperiod')
BEGIN
ALTER TABLE MNDIndicator ADD checkperiod NVARCHAR(100) NULL default ''
END


 

原文地址:https://www.cnblogs.com/snowball/p/745213.html