How to fetch next records one by one using loop in sql serve

Gagan Gautam

10y829SQL

How to fetch next records one by one from table using loop in sql serve

i have 100 records in table and now i i want to check one by one records using loop.

Plz Reply i every one know

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

ketan borsdiya10y ago
Accepted answer
Hi Gagan,
use cursor for looping in sql. Check below sample,
DECLARE @firstName as varchar(50),@lastName as varchar(50)
DECLARE db_cursor CURSOR FOR
SELECT FirstName,LastName
FROM TBL_TEST
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @firstName,@lastName
WHILE @@FETCH_STATUS = 0
BEGIN
Print(@firstName)
--Perform your operation
FETCH NEXT FROM db_cursor INTO @firstName,@lastName
END
CLOSE db_cursor
DEALLOCATE db_cursor
+1
ketan borsdiya10y ago
Yes Gagan
0
Nitin Sontakke10y ago
Hello,
As I stated before, technically everything is possible, but how exactly you do it is important, in long run.
I have always questioned individuals what they exactly want to achieve and in most cases avoided the cursors altogether.
From your comments, it is not clear, the precise requirement.
You can always proceed with answer at hand, though!
0
Gagan Gautam10y ago
Hello Ketan,
0
Gagan Gautam10y ago
Hi Nithin,
I want to match spcific records in 100 records. so that's i am used loop for fetchinf every record and than match it
0
Nitin Sontakke10y ago
It is easy to answer your question technically, but personally do not prefer that approach.
"What exactly are you trying to achieve?" is a more important question to ask here.
Please do let us know that.
May be there is a better solution available.
In general you should avoid going through each row on server side (called cursor) and should avoid it as much as possible.
0