sql server批量alter

DECLARE @table_name VARCHAR(50),@COLUMS VARCHAR(50)='AAA'
DECLARE FIRST_CURSOR CURSOR FOR SELECT   name FROM sys.tables
OPEN FIRST_CURSOR
FETCH NEXT FROM FIRST_CURSOR INTO @table_name
WHILE @@FETCH_STATUS=0
BEGIN
DECLARE @SQL VARCHAR(4000)=''

SET @SQL= 'ALTER table '+@table_name+' ADD '+@COLUMS+' VARCHAR(50)'
SELECT @SQL


FETCH NEXT FROM FIRST_CURSOR INTO @table_name
END


CLOSE FIRST_CURSOR

DEALLOCATE FIRST_CURSOR

原理为遍历游标 拼出sql 然后循环执行