DECLARE @ID uniqueidentifier
DECLARE cur_tmp CURSOR FOR select ID from table
OPEN cur_tmp
FETCH NEXT FROM cur_tmp INTO @ID -- 这里是取到select的值
WHILE @@FETCH_STATUS = 0
BEGIN
执行语句
FETCH NEXT FROM cur_tmp INTO @ID
END
CLOSE cur_tmp
DECLARE cur_tmp CURSOR FOR select ID from table
OPEN cur_tmp
FETCH NEXT FROM cur_tmp INTO @ID -- 这里是取到select的值
WHILE @@FETCH_STATUS = 0
BEGIN
执行语句
FETCH NEXT FROM cur_tmp INTO @ID
END
CLOSE cur_tmp