/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

0 vote338 views1 answer
Mysql in clausule string array
SQL
0 vote319 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote364 views1 answer
Transaction and commit trong sql server
SQL
0 vote415 views1 answer
Trigger
SQL
-1 vote350 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote354 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote343 views1 answer
Oracle service name view
SQL
3 votes321 views1 answer
Mysql replace string in table
SQL
0 vote345 views1 answer
Print boolean in plsql
SQL
0 vote347 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL