用游标呀!
DECLARE 游标名称 CURSOR FOR
SELECT *
FROM 表
ORDER BY 顺序FETCH NEXT FROM 游标名称
INTO @参数WHILE @@FETCH_STATUS = 0
BEGIN
做相应操作
FETCH NEXT FROM 游标名称
INTO @参数
endCLOSE 游标名称
DEALLOCATE 游标名称
DECLARE 游标名称 CURSOR FOR
SELECT *
FROM 表
ORDER BY 顺序FETCH NEXT FROM 游标名称
INTO @参数WHILE @@FETCH_STATUS = 0
BEGIN
做相应操作
FETCH NEXT FROM 游标名称
INTO @参数
endCLOSE 游标名称
DEALLOCATE 游标名称
select col1,col2,...
from tablename
open c1
fetch next from c1 into @col1,@col2,...
while @@fetch_status = 0
begin
--do what you want to
fetch next from c1 into @col1,@col2,...
end
close c1
deallocate c1
如果是你自己定义的顺序,用order by 阿,可以正序和倒序
SELECT *
FROM 表
ORDER BY 顺序FETCH NEXT FROM 游标名称
INTO @参数WHILE @@FETCH_STATUS = 0
BEGIN
做相应操作
FETCH NEXT FROM 游标名称
INTO @参数
endCLOSE 游标名称
DEALLOCATE 游标名称
[ INTO new_table ]
FROM table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]
rs.movenext