存储过程中raiserror后面的代码还能继续执行????!
ALTER PROCEDURE PKG_TEST_TTT1
@ReceiverID VARCHAR(8000),
@R NUMERIC(10)
AS
BEGIN
SET NOCOUNT ON
--raiserror ('error',16,1) with NOWAIT
drop table asdfasdfasdfasdf
insert into dual(dummy) values('y')
return 1
SET NOCOUNT OFF
END
GO
后面的INSERT语句还是会执行地,这点不是搞死人了吗?
有没有什么开关控制RAISERROR后过程中断呢/