22,199
社区成员
发帖
与我相关
我的任务
分享
Create PROCEDURE Test_sp_Raiserror
AS
BEGIN
-- exec Test_sp_Raiserror_inside
-- select * from Test_sp_raiserror_del
BEGIN TRY
Begin tran --开始--
insert into Test_sp_raiserror_del values('c')
exec Test_sp_Raiserror_inside
insert into Test_sp_raiserror_del values('d')
commit tran
select 'Succeed' Msg,'1' Results
END TRY
BEGIN CATCH
ROLLBACK TRAN
select '意外出错! '+error_message() Msg ,'0' Results
END CATCH
END
GO
create PROCEDURE Test_sp_Raiserror_inside
AS
BEGIN
drop table Test_sp_raiserror_del
select *
into Test_sp_raiserror_del
from (select 'a' Col) tmpa
RAISERROR ('Retur!', 16, 1) with nowait
return
insert into Test_sp_raiserror_del values('b')
END
GO