往表里面添加字段，测试最大添加多少列

create database TabTestgouse TabTestgocreate table tableTest(file1 varchar(10))goselect * from tableTestbegindeclare @count int,@strSQL varchar(100)set @count=2BEGIN TRANSACTION--开始事务DECLARE @errorSun INT --定义错误计数器SET @errorSun=0 --没错为0while @count<1026 begin set @strSQL='ALTER TABLE tableTest ADD file'+cast(@count as varchar(20))+' varchar(10)' exec(@strSQL)SET @errorSun=@errorSun+@@ERROR --累计是否有错set @count=@count+1 end IF @errorSun<>0BEGINPRINT '有错误，回滚 列号'+@countROLLBACK TRANSACTION--事务回滚语句ENDELSEBEGINPRINT '成功，提交'COMMIT TRANSACTION--事务提交语句ENDend