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

3 votes104 views1 answer
Oracle undo tablespace list by user
SQL
0 vote99 views4 answers
First max salary in sql
SQL
0 vote108 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote110 views1 answer
Create synonym for dblink in oracle
SQL
1 vote100 views1 answer
Sql myisam vs innodb
SQL
0 vote105 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote121 views1 answer
Sql today at midnight
SQL
0 vote133 views1 answer
Mysql where sum > 0
SQL
1 vote100 views1 answer
Oracle truncate partition
SQL
1 vote106 views3 answers
What is union in sql
SQL