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 vote129 views1 answer
Postgres select except
SQL
1 vote135 views2 answers
Postgresql get difference in hours between two dates
SQL
11 votes139 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote211 views1 answer
Bigrock database connection string
SQL
-1 vote129 views1 answer
Io
SQL
0 vote126 views1 answer
Oracle search columns in schema
SQL
-1 vote165 views1 answer
Add 10 to all numbers in a column sql
SQL
2 votes155 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
6 votes169 views3 answers
Rename column ORACLE
SQL
0 vote137 views1 answer
How to put value in parameters in mysqldataadapter
SQL