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
如何在程序中直接捕获“授权号重复,请检查!”错误,并提示“授权号重复,请检查”
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
如何在程序中直接捕获“授权号重复,请检查!”错误,并提示“授权号重复,请检查”
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货