27,580
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)
set @sql = ''
select @sql = @sql
+ 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' + char(13)
+ name + char(13)
+ 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' + char(13)
from syscolumns where id = object_id('sysobjects')
print(@sql)
select len(@sql)
set @sql = @sql + 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
declare @a varchar
set @a = 'aaa'
print @a
declare @sql varchar(8000),@co int
set @sql = ''
set @co = 1
while @co <= 99
begin
set @sql = @sql + 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
set @co = @co + 1
end
print len(@sql)
set @sql = @sql + char(13)
print len(@sql)
--随便加一列
select @sql = @sql + name from syscolumns where name = 'rowsetid' and id = 4
print len(@sql)
/*
结果:
8000
8000
4000
*/