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

17 votes165 views6 answers
What is cursor in sql server with example
SQL
58 votes352 views6 answers
Create new user in postgres
SQL
15 votes198 views3 answers
Postgresql change column type
SQL
15 votes201 views2 answers
Select Options
SQL
0 vote202 views1 answer
Create schema sql server
SQL
0 vote182 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote149 views1 answer
Import csv to mysql
SQL
0 vote209 views1 answer
Mysql bash execute sql file
SQL
0 vote212 views3 answers
Fetlife
SQL
0 vote201 views1 answer
Allow external access to mysql
SQL