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

2 votes188 views1 answer
Oracle block
SQL
2 votes183 views2 answers
Mysql add hours to time field
SQL
0 vote169 views1 answer
Oracle sqlp update amount / quantity
SQL
1 vote171 views1 answer
Pl sql insert into table
SQL
0 vote184 views1 answer
SQL Server rename foreign key constraint
SQL
1 vote178 views1 answer
Oracle drop chain step
SQL
8 votes169 views3 answers
Postgresql connection string c#
SQL
11 votes183 views2 answers
Insert date sql
SQL
0 vote215 views1 answer
How to check rollback status in oracle
SQL
7 votes216 views1 answer
Show line number in sql server
SQL