sql - 对一系列元素执行过程(执行 theProc(从表中选择 id))

Question

我需要为这个选择查询返回的每个元素执行过程 deleteQuestion:

select id from questions where Stuff = @Stuff

execute deleteQuestion id

类似于:
执行 deleteQuestion each(select id fom questions where Stuff = @Stuff)

有人知道吗？

Answer 1

使用 cursor :

DECLARE @Id INT
DECLARE your_cursor CURSOR FOR 
SELECT id from questions where Stuff = @Stuff 

OPEN your_cursor 

FETCH NEXT FROM your_cursor 
INTO @Id

WHILE @@FETCH_STATUS = 0
BEGIN

    execute deleteQuestion @Id

    FETCH NEXT FROM your_cursor 
        INTO @Id

END 
CLOSE your_cursor
DEALLOCATE your_cursor