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 vote165 views1 answer
Declare variables sql
SQL
0 vote193 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote169 views1 answer
How to create a new db from dumb file mysql
SQL
10 votes177 views2 answers
Sql pagination offset
SQL
2 votes172 views2 answers
Mysql add hours to time field
SQL
0 vote166 views1 answer
Insert or update sql firebird
SQL
0 vote227 views1 answer
Oracle db get table sizes
SQL
4 votes169 views3 answers
Is not null sql
SQL
1 vote156 views1 answer
Oracle update with sequence
SQL
1 vote152 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL