上班之余抽點時間出來寫寫博文，希望對新接觸的朋友有幫助。今天在這里和大家一起學習一下游標刪除

????創立游標：

????

?????

    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
  

文章結束給大家分享下程序員的一些笑話語錄： 手機終究會變成PC，所以ip會比wm更加暢銷，但是有一天手機強大到一定程度了就會發現只有wm的支持才能完美享受。就好比樹和草，草長得再高也是草，時間到了條件成熟了樹就會竄天高了。www.ishuo.cn

游標刪除游標的使用和操作