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 vote340 views2 answers
Faster mysql imports
SQL
0 vote322 views1 answer
Select count postgres double row count > 1
SQL
2 votes325 views1 answer
Get first 2 letter in sql
SQL
0 vote344 views1 answer
Watch mysql command line
SQL
0 vote321 views1 answer
Opensuse stop MySQL
SQL
0 vote333 views1 answer
C# mysql update statement set value to null
SQL
0 vote342 views1 answer
Select all same column value in sql
SQL
0 vote299 views1 answer
Mysql group rows with same value
SQL
0 vote332 views3 answers
Sql drop all tables
SQL
0 vote348 views1 answer
Check user sql password from command line
SQL