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 vote261 views1 answer
List all triggers in SQL Server
SQL
1 vote253 views1 answer
Grab all records from one table to another oracle sql
SQL
6 votes259 views4 answers
Remove spaces sql server
SQL
-1 vote255 views1 answer
Ssms connect with connection string
SQL
0 vote264 views1 answer
Get all employee of salary if more than in sql
SQL
7 votes231 views1 answer
Mysql load data infile csv
SQL
0 vote259 views1 answer
Sql select max value for each group
SQL
0 vote257 views1 answer
Max mysql
SQL
5 votes217 views1 answer
Alter table default value mysql
SQL
0 vote269 views1 answer
Oracle change password expiration policy
SQL