游标的使用和操作

创建游标：

[sql]

alter PROC proc_order

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

删除创建的游标：

[sql]

DEALLOCATE myCursor2