sqlsever sql

方便的复制一条数据

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