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 vote277 views1 answer
Sql convert float to string
SQL
3 votes260 views1 answer
Oracle undo tablespace list by user
SQL
38 votes322 views6 answers
Alter table mysql
SQL
1 vote262 views1 answer
Sqlite check if row exists
SQL
4 votes319 views4 answers
Remove duplicate old value in mysql
SQL
2 votes256 views1 answer
Mysql sysdate
SQL
0 vote309 views1 answer
Create-table-with-index-organization
SQL
0 vote282 views1 answer
Get sum sqlite android
SQL
0 vote256 views1 answer
Take sql dump in to file
SQL
1 vote271 views1 answer
Show all event schedular on mysql
SQL