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

Question

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

ketan borsdiya · 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 FirstNameLastName 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

ketan borsdiya · Answer

Yes Gagan

Nitin Sontakke · Answer

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!

Gagan Gautam · Answer

Hello Ketan

Gagan Gautam · Answer

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

Nitin Sontakke · Answer

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.