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 vote118 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote105 views1 answer
Group by 15 minute interval sql server
SQL
0 vote119 views2 answers
T sql null or empty string
SQL
0 vote104 views1 answer
Stuff in sql server
SQL
0 vote172 views1 answer
Tsql find procedure with name
SQL
1 vote101 views1 answer
Delete triger pl pg sql
SQL
0 vote107 views1 answer
Sql get date from timestamp
SQL
0 vote119 views1 answer
Ffeathers express mysql application users login
SQL
0 vote151 views1 answer
Sql multiple into
SQL
1 vote115 views1 answer
Oracle list constraints
SQL