向數據表批量添加欄位

 declare @ItemNO nvarchar(10),
            @sql         nvarchar(1000) 

DECLARE FC_3S_Cursor CURSOR FOR
SELECT ItemNO  FROM dbo.FC_3DAnalyse
OPEN FC_3S_Cursor
FETCH NEXT FROM FC_3S_Cursor
INTO @ItemNO
WHILE @@FETCH_STATUS = 0
BEGIN

SET @ItemNO='A'+@ItemNO
SET @sql='ALTER TABLE FC_SD   ADD '+ @ItemNO+' int  not null default(0)'
exec(@sql)

FETCH NEXT FROM FC_3S_Cursor    INTO @ItemNO
END
CLOSE FC_3S_Cursor
DEALLOCATE FC_3S_Cursor

 

转载于:https://www.cnblogs.com/dg123/archive/2009/01/23/1380451.html