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

5 votes171 views1 answer
Oracle scan source ddl
SQL
17 votes180 views3 answers
Cast in sql server
SQL
0 vote163 views1 answer
Error code 1241 mysql
SQL
1 vote192 views1 answer
Table valued functions in sql
SQL
0 vote188 views1 answer
Show table details postgresql
SQL
4 votes237 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote180 views1 answer
Soql update query
SQL
33 votes182 views6 answers
Sql delete
SQL
11 votes179 views2 answers
Having clause in sql
SQL
0 vote172 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL