商店程序的执行状态 [英] execution status of store procedure

问题描述

Alter procedure CallProcedure
AS
Begin 
truncate table Primary_Duplicate;
truncate table Secondary_Duplicate;
begin try
EXEC Allexactmatch;

end try
begin catch	

	end catch
	begin try
EXEC No_EngNo;
end try
begin catch	
	end catch
	
begin try
EXEC No_HullNo;
end try
begin catch		
	end catch
	
begin try
EXEC NO_OW;
end try
begin catch		
	end catch
		begin try
EXEC exactmatchNoDelDate;
end try
begin catch		
	end catch

	begin try
EXEC NO_OW_YA_Date;
end try
begin catch
		
	end catch	

	
begin try
EXEC No_Lic;
end try
begin catch
		
	end catch
begin try
EXEC No_Lic_Ow;
end try
begin catch
		
	end catch
begin try
EXEC No_Lic_ya;
end try
begin catch
		
	end catch

	begin try
EXEC 	No_Lic_Date;
end try
begin catch
		
	end catch
	
	begin try
EXEC No_HNO_ow_ya_date;
end try
begin catch
		
	end catch
	begin try
EXEC ENO_ETypeLikelyMatch_NO_OW_YA_LIC;
end try
begin catch
		
	end catch
		begin try
EXEC ENO_ETypeLikelyMatch_NO_OW_YA_LIC_date;
end try
begin catch
		
	end catch
    
    
END

我怎么知道哪个程序在运行时已经完成

How would i know which procedure is completed while it's running

推荐答案

你可以做这样的事情来了解你当前的执行状态

You can do something like this to know your current execution state

begin try
EXEC Allexactmatch;

 PRINT N'EXEC Allexactmatch - Completed.';

end try

你可以使用在所有存储过程中打印

You can use this print in all your stored procedure

这篇关于商店程序的执行状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！