游标的使用和操作

于 2013-05-06 15:52:00 发布 · 108 阅读

本文详细介绍了如何使用SQL创建游标，并通过游标进行数据检索与操作，包括声明游标、打开游标、执行操作及关闭游标等关键步骤。

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

创建游标：

alter PROC proc_order
 
 AS

   	DECLARE @uid INT
	DECLARE @pid INT
	DECLARE @number INT
	DECLARE cu_order CURSOR 
	FOR SELECT c.uid,c.pid,c.number 
	    FROM shopCar AS c INNER JOIN userTable AS u 
	    ON u.uid=c.uid WHERE u.userName=@userName
	    
	OPEN cu_order
	FETCH NEXT FROM cu_order INTO @uid,@pid,@number
	WHILE @@FETCH_STATUS=0
	BEGIN
		--PRINT @uid
		INSERT INTO orderDetails VALUES(@orderID,@pid,@uid,@number)
		FETCH NEXT FROM cu_order INTO @uid,@pid,@number
	END
	CLOSE cu_order
	DEALLOCATE cu_order

删除创建的游标：