CREATE TRIGGER [bcb_repayments] ON [dbo].[test]
FOR INSERT
AS begin
declare @LoanUID varchar(20)
declare @Date datetime
declare @Capital money
declare @Interest money
DECLARE @sERROR varchar(1000) --Error text
select @LoanUID=Col001 from inserted
select @Date=convert(datetime,Col003,101) from inserted
select @Capital=convert(money,Col004) from inserted
select @Interest=convert(money,Col005) from inserted
EXECUTE pp_UMLP_RegisterRepayment
@LoanUID=@LoanUID,@Date=@Date,@Capital=@Capital,@Interest=@Interest
end delete from [dbo].[test] IF @@ERROR<>0
BEGIN
SET @sERROR='Error to register payment !'
GOTO RAISE_ERR
END
RETURNRAISE_ERR:
IF @@TRANCOUNT > 0 ROLLBACK TRAN
RAISERROR(@sERROR, 16, 1)
RETURN
FOR INSERT
AS begin
declare @LoanUID varchar(20)
declare @Date datetime
declare @Capital money
declare @Interest money
DECLARE @sERROR varchar(1000) --Error text
select @LoanUID=Col001 from inserted
select @Date=convert(datetime,Col003,101) from inserted
select @Capital=convert(money,Col004) from inserted
select @Interest=convert(money,Col005) from inserted
EXECUTE pp_UMLP_RegisterRepayment
@LoanUID=@LoanUID,@Date=@Date,@Capital=@Capital,@Interest=@Interest
end delete from [dbo].[test] IF @@ERROR<>0
BEGIN
SET @sERROR='Error to register payment !'
GOTO RAISE_ERR
END
RETURNRAISE_ERR:
IF @@TRANCOUNT > 0 ROLLBACK TRAN
RAISERROR(@sERROR, 16, 1)
RETURN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货