触发器的问题·

[fgh0302]

Create trigger chebuding_delete
On qk_chebuding
for delete
as
begin
declare @fenshu int
declare @kanhao varchar(20)
declare @kehuhao varchar(20)
declare @qishu varchar(20)
declare @niandu varchar(20)
select @fenshu=fenshu,@kanhao=kanhao,@kehuhao=danweidaima,@qishu=kanqi,@niandu=niandu from deleted
update dingshuzongbiao set chebudingshu=chebudingshu-@fenshu
Where dingshuzongbiao.kanhao=@kanhao and dingshuzongbiao.qishu=@qishu and dingshuzongbiao.niandu=@niandu
update fenjianbiao set yudingshu=yudingshu-@fenshu
where fenjianbiao.kanhao=@kanhao and fenjianbiao.kehuhao=@kehuhao and fenjianbiao.qishu=@qishu and fenjianbiao.niandu=@niandu
end
我想如果这个触发器 执行失败的话 抛出一个错误，前台接受下，并且表的delete操作也回滚！请问该怎么写！

[ximi82878]

自定义错误消息： raiserror( '你要写的错误消息 ',18,18)


触发器回滚建议参考：http://zhidao.baidu.com/question/41154067.html

[fgh0302]

没人解答啊！·