declare @a ...,@b...,@c...--变量定义 declare crsrDemo cursor for Select a,b,c... From 表名 Where 条件 Order by 排序字段名列表 open crsrDemo Fetch Next From crsrDemo Into @a, @b, @c... while @@FETCH_STATUS = 0 begin ....--做一些处理 end Close crsrDemo Deallocate crsrDemo ....
----------------------------------------------
-广袤璀璨的银河,永无止境的梦想(梦无止境游银河) 博客挂了……