Sql server loop over query

DECLARE @id INT
DECLARE @name NVARCHAR(100)
DECLARE @getid CURSOR

SET @getid = CURSOR FOR
SELECT table.id,
       table.name
FROM   table

OPEN @getid
FETCH NEXT
FROM @getid INTO @id, @name
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC stored_proc @varName=@id, @otherVarName='test', @varForName=@name
    FETCH NEXT
    FROM @getid INTO @id, @name
END

CLOSE @getid
DEALLOCATE @getid

Source: stackoverflow.com

Similar codes

0 vote359 views1 answer
Mysql select smaller of two values
SQL
1 vote370 views1 answer
Increase existing date in sql
SQL
13 votes382 views3 answers
Insert mysql ifile nto database
SQL
0 vote367 views1 answer
Sql remove decimal places
SQL
11 votes379 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote361 views1 answer
Selecting from a view SQL
SQL
6 votes370 views1 answer
Postgres get size of database
SQL
0 vote380 views1 answer
Prodection ready postgres database step by step
SQL
0 vote343 views1 answer
Sqlalchemy case insensitive like
SQL
2 votes382 views1 answer
Sql percentage with % rounded down
SQL