说明
接上篇,此篇描述SqlServer的写法
存储过程
BEGIN
DECLARE @audittable varchar(200);
DECLARE @sqlstring varchar(200);
SET @audittable = ('gspaudit' + substring(CONVERT(varchar(100), GETDATE(), 112),3,4));
SET @sqlstring = 'alter table ' + @audittable + ' add seclevel VARCHAR(256)';
IF EXISTS(select 1 FROM sysobjects WHERE name = @audittable)
BEGIN
IF NOT EXISTS(SELECT 1 FROM SYS.SYSCOLUMNS A WHERE A.ID = OBJECT_ID(@audittable) AND A.NAME = 'seclevel' )
BEGIN
EXEC (@sqlstring);
END;
END;
END;
注意事项
1、SqlServer中变量赋值要加@
2、字符串连接可以使用“+”