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 vote229 views1 answer
How to make sure two tables have same exact data in sql
SQL
62 votes485 views8 answers
Mysql add column
SQL
12 votes174 views5 answers
Sql merge
SQL
12 votes194 views1 answer
How to change the value of a table in sql
SQL
0 vote194 views1 answer
Oracle sql generate list of days
SQL
6 votes184 views1 answer
Wordpress change user password sql
SQL
3 votes191 views5 answers
Mysql get last inserted id
SQL
0 vote203 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
4 votes234 views2 answers
Insert current date in mysql
SQL
0 vote223 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL