如何捕获触发器中的错误

[ducklyxh]

CREATE TRIGGER checkrightno_forcust ON [dbo].[B_Customer]
FOR INSERT, UPDATE
AS
--检查授权号重复性
if exists(select v.* from inserted v join b_customer t1 on t1.frightno=v.frightno
where v.frightno<>'' and v.finterid<>t1.finterid)
begin
raiserror('授权号重复，请检查!',16,1)
end


如何在程序中直接捕获“授权号重复，请检查!”错误，并提示“授权号重复，请检查”

[liangpei2008]

Use Try Except command
example:

Try
  OperationForDatabase...
Except
  on E:Exception do
  begin
    Raise Exception.create(E.Message)
  end;
End;

[ducklyxh]

我先试一试