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

0 vote264 views2 answers
Sql max count
SQL
0 vote284 views1 answer
Datatables server side filter where clause
SQL
2 votes268 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote272 views1 answer
Like date sql server not working
SQL
0 vote255 views1 answer
Min and max salary and name in sql
SQL
0 vote269 views1 answer
What alter does in db
SQL
0 vote249 views1 answer
Python mysql query where
SQL
0 vote250 views1 answer
MySQL FIND_IN_SET()
SQL
-1 vote252 views1 answer
Mysql coalesce
SQL
21 votes257 views3 answers
Average sql
SQL