/*
游标使用步骤:
DECLARE CURSOR 定义 Transact-SQL 服务器游标的属性,例如游标的滚动行为和用于生成游标所操作的结果集的查询。
OPEN 语句填充结果集,
FETCH 从结果集返回行。
CLOSE 语句释放与游标关联的当前结果集。
DEALLOCATE 语句释放游标所使用的资源。
声明游标语法:
DECLARE cursor_name CURSOR [ LOCAL | GLOBAL ]
[ FORWARD_ONLY | SCROLL ]
[ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ]
[ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ]
[ TYPE_WARNING ]
FOR select_statement
[ FOR UPDATE [ OF column_name [ ,...n ] ] ]
*/
--测试
SET NOCOUNT ON
DECLARE @GUID UNIQUEIDENTIFIER
DECLARE @NAME VARCHAR(50)
DECLARE @VALUE DECIMAL(18,4)
DECLARE @InsertDate DATETIME
DECLARE @Mark bit
DECLARE MYCUR CURSOR TYPE_WARNING
FOR SELECT [Guid],[Name],[Value],[InsertDate],[Mark] FROM [dbo].[CURTAB]
-- FOR UPDATE OF [Value]
OPEN MYCUR
--FETCH FIRST FROM MYCUR INTO @GUID,@NAME,@VALUE,@InsertDate,@Mark
FETCH NEXT FROM MYCUR INTO @GUID,@