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

1 vote142 views1 answer
Install postgresql on raspberry pi
SQL
58 votes315 views6 answers
Create new user in postgres
SQL
0 vote155 views1 answer
Declaring variables in pl sql
SQL
-3 votes125 views1 answer
Remove spaces sql 2008
SQL
0 vote134 views1 answer
Datetime postgres typeorm
SQL
94 votes182 views4 answers
Create database postgres
SQL
2 votes123 views1 answer
Wait delay in sql server
SQL
0 vote142 views1 answer
How to reset the database value in SQL server
SQL
0 vote144 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote148 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL