方便的复制一条数据
insert into dbo.t2 (id,f1,f2,f3,f4)select 'id1',f1,f2,f3,f4 from dbo.t2
快速查询1条数据
with temp as (select row_number() over(order by name) as rownum, ia.id from dbo.t3) select * from temp where rownum between 1 and 1
方便的复制一条数据
insert into dbo.t2 (id,f1,f2,f3,f4)select 'id1',f1,f2,f3,f4 from dbo.t2
快速查询1条数据
with temp as (select row_number() over(order by name) as rownum, ia.id from dbo.t3) select * from temp where rownum between 1 and 1