/SQL/Loop through a table variable in TSQL without using a cursor

Loop through a table variable in TSQL without using a cursor

Declare @Id int
While (Select Count(*) From ATable Where Processed = 0) > 0
Begin
    Select Top 1 @Id = Id From ATable Where Processed = 0
    --Do some processing here
    Update ATable Set Processed = 1 Where Id = @Id 
End

Source: stackoverflow.com

Similar codes

11 votes353 views5 answers
How to install sqlite3 python
SQL
0 vote321 views1 answer
Sqlite3 now
SQL
0 vote350 views1 answer
Function sum(text) does not exist postgres
SQL
1 vote362 views1 answer
How to show index type in postgresql
SQL
8 votes379 views1 answer
My sql version
SQL
0 vote345 views1 answer
How to find sql server name
SQL
0 vote351 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote331 views1 answer
Autocommit mysql
SQL
8 votes370 views1 answer
Check mysql version phpmyadmin
SQL
3 votes359 views2 answers
Oracle privileges users
SQL