T-SQl 游标

最新推荐文章于 2025-01-10 12:13:30 发布

weixin_30827565

最新推荐文章于 2025-01-10 12:13:30 发布

阅读量82

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/liwenchaoCode/p/5830075.html

本文详细介绍了SQL中游标的使用方法，包括不同类型的游标声明、打开、关闭及释放等操作，并通过具体示例展示了如何利用游标进行数据处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

use Test

---定义后直接赋值
Declare test_Cursor CURSOR FORWARD_ONLY FOR
SELECT * FROM [Test].[dbo].[TrackLog]

----先定义后赋值
Declare @TEST_Cursor2 CURSOR
SET @TEST_Cursor2= CURSOR FOR
SELECT * FROM [Test].[dbo].[TrackLog]

------全局游标跨LOCAL
DECLARE test_Cursor3 CURSOR GLOBAL SCROLL FOR
SELECT fullname FROM [Test].[dbo].[TrackLog]

------局部游标，跨Local
DECLARE test_Cursor4 CURSOR LOCAL FOR
SELECT * FROM [Test].[dbo].[TrackLog]

DEALLOCATE test_Cursor3
DEALLOCATE test_Cursor

OPEN test_Cursor3;
DECLARE @C NVarchar(100)
FETCH LAST FROM test_Cursor3 into @c
print @c
FETCH PRIOR FROM test_Cursor3 into @c
print @c
FETCH NEXT FROM test_Cursor3 into @c
print @c
FETCH FIRST FROM test_Cursor3 into @c
print @c
FETCH NEXT FROM test_Cursor3 into @c
print @c
FETCH ABSOLUTE 2 FROM test_Cursor3 into @c
print @c
FETCH RELATIVE 2 FROM TEST_CURSOR3 into @c
print @c

DEALLOCATE CursorTest_Scroll
DECLARE CursorTest_Scroll CURSOR SCROLL FOR
SELECT * FROM [Test].[dbo].[TrackLog]

OPEN CursorTest_Scroll
DECLARE @ID int
Declare @Fullname nvarchar(100)
Declare @METHODNAME nvarchar(100)
Declare @EXECUTETIME nvarchar(100)
Declare @ROWDATE nvarchar(100)
Declare @STATUS nvarchar(100)
Declare @MESSAGE nvarchar(100)
Declare @CLIENTIP nvarchar(100)
Declare @CITYCODE nvarchar(100)
WHILE @@FETCH_STATUS=0
BEGIN
PRINT @ID
PRINT @FULLNAME
PRINT @METHODNAME
FETCH NEXT FROM CursorTest_Scroll INTO @ID,@FULLNAME,@METHODNAME,@EXECUTETIME,@ROWDATE,@STATUS,@MESSAGE,@CLIENTIP,@CITYCODE
END
CLOSE CursorTest_Scroll
DEALLOCATE CursorTest_Scroll