declare
@id int,
@sql nvarchar(max),
@last_result nvarchar(100),
@last_runtime datetime,
@params nvarchar(max);
SET @params = N'@retvalOUT varchar(max) OUTPUT';
select @id = min(id) from Test_Run;
while @id is not null
begin
select @sql = Script from Test_Run where id = @id;
set @sql = 'select @retvalOUT= (' + @sql + ')';
exec sp_executesql @sql, @params, @retvalOUT = @last_result OUTPUT;
set @last_runtime = getdate();
update Test_Run set Last_Result = @last_result, Last_Runtime = @last_runtime where id = @id;
select @id = min(id) from Test_Run where id > @id;
end
我完全删除了游标，并使用了while循环-我猜我不太喜欢游标:-)
602392714
清零编程群