SQL Server 2008 游标

[liushui9]

使用游标将SPJ表中的偶数行输出，SQL语句应该怎么写？

[q465897859]

select * from (select *,row_number() over(order by getdate()) rid from SPJ) a where rid%2=0

[seusoftware]

用CTE就可以了，游标尽量避免使用。

with t
as
(
select *,ROW_NUMBER() OVER(order by (select 1)) as num
from SPJ
)
select * from t where num%2 = 0

[唐诗三百首]

declare ap cursor for
 select [字段列表] from
 (select *,row_number() over(order by getdate()) 'rn' from SPJ) t
 where t.rn%2=0

open ap

fetch first from ap into [变量列表]
while(@@fetch_status<>-1)
begin
  [处理代码]
  fetch next from ap into [变量列表]
end

close ap
deallocate ap

[daiyueqiang2045]

函数%2 就OK