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 vote161 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote155 views1 answer
Create or replace view postgress
SQL
1 vote147 views1 answer
Delete row mssql
SQL
0 vote142 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote146 views2 answers
Mysql on update current_timestamp
SQL
16 votes158 views4 answers
Mysql import from sql file
SQL
0 vote151 views1 answer
Mysql shell set time_zone
SQL
0 vote157 views1 answer
Trigger vérifier stock
SQL
3 votes152 views2 answers
Mysql HAVING
SQL
0 vote135 views1 answer
Sub blocks in sql
SQL