loop in ms sql 2000

[b00gieman]

Hi!
Is there a possible way for looping through the records of a table(like using foreach - oracle)?

 

[mrdenny]

Yes it's called a FETCH cursor. 99% of the time it's better to not use a cursor in SQL Server. SQL Server processes data is a ROWSET faster than a fetch cursor.

DECLARE @name as nvarchar(128)
DECLARE MyCursor CURSOR FOR SELECT name from sysdatabases
open MyCursor
FETCH NEXT FROM MyCursor into @name
WHILE @@FETCH_STATUS = 0
BEGIN
     --Do something with the variable here.
     FETCH NEXT FROM MyCursor into @name
END
CLOSE MyCursor
DEALLOCATE MyCursor

What's the end result that you are trying to get to?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[b00gieman]

I'm trying to select some rows that fulfill a certain condition.For each row,I want to gather some information and use it...

 

[mrdenny]

In that case carry on with your cursor. That would pretty much be one of the few cases where cursors are probably going to be needed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com