游标的使用和操作

创建游标：

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

删除创建的游标：

DEALLOCATE  myCursor2