foreach loop in sql server

[xs]

May I know if there is a foreach loop equivalent found in Sql Server? I
would like to use 1 in sprocs.

 

[Janaka]

First I'd recommend re-evaluating your tsql and checking whether a loop is
necessary. If it is then you should try using a cursor to loop through your
results. Have a look at
http://www.databasejournal.com/features/mssql/article.php/1439731

J

 

[Cor Ligthert]

Hi XS,

I think that you can have a look on msdn for SqlDatareader

I hope this helps/

Cor

 

[Jon Skeet [C# MVP]]

May I know if there is a foreach loop equivalent found in Sql Server? I
would like to use 1 in sprocs.

I would suggest asking in a SqlServer group - perhaps
microsoft.public.sqlserver.programming would be good.

 

[William Ryan eMVP]

You can use While loops to get to the same place. Depending on what you
need to do you can use Cursors also but in most cases you don't want to go
there b/c they are a tad slow.

Cheers,

Bill








--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

I agree with posting in a SQL group, preferably
microsoft.public.sqlserver.programming

You will want to look at cursors. Not exactly what you are looking for, as
objects are treated differently in SQL Server than code, but you can loop
through a cursor and check data items for matches.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************