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 vote255 views1 answer
Create table employees oracle
SQL
2 votes285 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote273 views1 answer
Mysql procedure between two tables
SQL
0 vote269 views1 answer
Mysql wsrep ls
SQL
0 vote311 views1 answer
Get role postgres
SQL
0 vote298 views1 answer
Sql query use select name inside where clause
SQL
0 vote245 views1 answer
Grant owner postgresql
SQL
33 votes278 views2 answers
Postgres how to add field created at
SQL
0 vote297 views1 answer
Postgres get database encoding
SQL
0 vote300 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL