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 vote321 views2 answers
Create new table plsql
SQL
24 votes325 views5 answers
Sql server insert into select
SQL
-1 vote321 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote347 views1 answer
Mysql show category once count how many products
SQL
1 vote352 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote332 views1 answer
Create database store
SQL
0 vote363 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote339 views1 answer
Sql server convert to guid
SQL
11 votes337 views1 answer
Get ddl materialized view oracle
SQL
0 vote309 views1 answer
Sql compound operators
SQL