TSqlTop用法

create table dbo.FinanceMonth
(MonthNum int ,
quantity int
)

;with cte as
(
    select 1 as MonthNum,100 as quantity
    union all
    select MonthNum+1,quantity+100
    from cte
    where MonthNum<12
)
insert into dbo.FinanceMonth
select *
from cte

SET ROWCOUNT 2

select *
from dbo.FinanceMonth

--等价于

select top 2 *
from dbo.FinanceMonth

SET ROWCOUNT 0

delete top (2)
from dbo.FinanceMonth

update top(2) dbo.FinanceMonth
set quantity=1

insert top(2) into  dbo.FinanceMonth
select * from dbo.FinanceMonth