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 vote223 views4 answers
Sql now
SQL
1 vote230 views1 answer
Raw query must include primary key
SQL
1 vote232 views1 answer
Join first name and last name sql
SQL
4 votes233 views3 answers
NOT NULL SQL
SQL
0 vote226 views1 answer
Datagrip exec
SQL
9 votes228 views1 answer
Mysql check date range
SQL
0 vote200 views1 answer
Mysql date + 1 day
SQL
0 vote215 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
3 votes212 views1 answer
Oracle undo tablespace list by user
SQL
3 votes204 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL