34,588
社区成员
发帖
与我相关
我的任务
分享
Select Lab_No,Test_Result_ID into #test From Inserted i,RST_TEST_RESULT rst
where i.Lab_No=rst.Lab_No
declare triger_cursor1 cursor for
Select Lab_No,Test_Result_ID From #test;
open triger_cursor1 fetch next from triger_cursor1 into @LabNo,@TestResultID
while(@@fetch_status=0)
begin
select @LabNo,@TestResultID
Fetch Next From triger_cursor1 InTo @LabNo,@TestResultID
end
close triger_cursor1
deallocate triger_cursor1
Select Lab_No,Test_Result_ID into #test From Inserted i,RST_TEST_RESULT rst
where i.Lab_No=rst.Lab_No
declare triger_cursor1 cursor for
Select Lab_No,Test_Result_ID From #test;
open triger_cursor1 fetch next from triger_cursor1 into @LabNo,@TestResultID
while(@@fetch_status=0)
begin
print('test')
Fetch Next From triger_cursor1 InTo @LabNo,@TestResultID
end
close triger_cursor1
deallocate triger_cursor1
Select Lab_No,Test_Result_ID into #test From Inserted i,RST_TEST_RESULT rst
where i.Lab_No=rst.Lab_No
declare triger_cursor1 cursor for
Select Lab_No,Test_Result_ID From #test;
open triger_cursor1 fetch next from triger_cursor1 into @LabNo,@TestResultID
while(@@fetch_status=0)
begin
exec refeSearch @TestResultID,@reference='a',@flag='b'
exec CalculatePrice @LabNo;
Fetch Next From triger_cursor1 InTo @LabNo,@TestResultID
end
close triger_cursor1
deallocate triger_cursor1
Select Lab_No,Test_Result_ID into #test From Inserted i,RST_TEST_RESULT rst
where i.Lab_No=rst.Lab_No
declare triger_cursor1 cursor for
Select Lab_No,Test_Result_ID From #test;
open triger_cursor1 fetch next from triger_cursor1 into @LabNo,@TestResultID
while(@@fetch_status=0)
begin
exec refeSearch @TestResultID,@reference='a',@flag='b'
exec CalculatePrice @LabNo;
Fetch Next From triger_cursor1 InTo @LabNo
end
close triger_cursor1
deallocate triger_cursor1
declare triger_cursor1 cursor for
Select Lab_No From Inserted;
open triger_cursor1 fetch next from triger_cursor1 into @LabNo
while(@@fetch_status=0)
begin
declare triger_cursor2 cursor for
Select Test_Result_ID From RST_TEST_RESULT where Lab_No = @LabNo;
open triger_cursor2
fetch next from triger_cursor2 into @TestResultID
while(@@fetch_status=0)
begin
exec refeSearch @TestResultID,@reference='a',@flag='b'
Fetch Next From triger_cursor2 InTo @TestResultID
end
close triger_cursor2 --
deallocate triger_cursor2 --
exec CalculatePrice @LabNo;
Fetch Next From triger_cursor1 InTo @LabNo