将某条记录复制300条

[Newlychen]

表T1(f1,f2)

f1 f2
a b

将记录 a,b复制300行，请SQL

[中国风]

--> --> (Roy)生成測試數據
 
if not object_id('Tempdb..#T') is null
	drop table #T
Go
Create table #T([f1] nvarchar(1),[f2] nvarchar(1))
Insert #T
select N'a',N'b'
Go
Select top 300 a.f1,a.f2 from #T as a,syscolumns as b,syscolumns as c ,syscolumns as d

[中国风]

多连接几个表，产生笛卡尔集，用top 限制显示行

[Newlychen]

产生笛卡尔集，

多谢

[@信心]

Create Procedure CopyRows
as
declare @ rownums int
set rownums=30
while @rownums<=30
insert into t1(f1,f2) select f1,f2 from t1
set @rownums=@rownums-1

[lh412552703]

[Quote=引用 4 楼 best_caohit 的回复:]
Create Procedure CopyRows
as
declare @ rownums int
set rownums=30
while @rownums<=30
insert into t1(f1,f2) select f1,f2 from t1
set @rownums=@rownums-1
[/Quote]

支持这种说法.