Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Looping in procedure ?

Author  Topic 

joshherman
Starting Member

13 Posts

Posted - 2012-02-15 : 21:57:47
Hello All,

How to looping data in SQL Server store procedure.

for example i want to do this order detail tabel:

select product_id,qty from order_detail
Do
.....
Loop

how to implement in Store Procedure.

thank you

kcanakli
Starting Member

8 Posts

Posted - 2012-02-16 : 02:10:45
You can use fetch row technique
Go to Top of Page

kcanakli
Starting Member

8 Posts

Posted - 2012-02-16 : 02:12:34
http://msdn.microsoft.com/en-us/library/ms180152.aspx
Go to Top of Page
   

- Advertisement -