【Helpers】实用 T-SQL 集合
更新奇数行记录
update t
set [field1] = 1
from (select ROW_NUMBER() OVER(ORDER BY [field2]) % 2 as odd_even, [field1]
from table) as t
where odd_even = 1;
注:where odd_even = 0 为偶数行记录。
posted on 2011-07-09 01:20 CsharpStyle 阅读(122) 评论(0) 编辑 收藏 举报