摘要:
declare @index int;declare @sql nvarchar(2000);set @index=1;while @index<=851 beginset @sql='alter table visitlog'+CONVERT(NVARCHAR(20), @index)+' alter column [OS] nvarchar(30) null;';set @index=@index+1;begin tryexec(@sql);end tryBEGIN CATCH print 'error'; print @index; 阅读全文