34,587
社区成员
发帖
与我相关
我的任务
分享
insert into #temp(other)
select 'num'+rtrim(number)
from master.dbo.spt_values
where type='P'
and number between 1 and 100
declare @times int,@i int
declare @sql nvarchar(1000)
select @times=100,
@i=1,
@sql=N'insert into #temp(other) values(''XX''); '
while(@i<=@times)
begin
exec(@sql)
set @i=@i+1
end