create trigger tri_name on 职工表 for insert ,update as if exists(select 1 from 职工表 where left(职工号,6) not in (select 仓库号 from 仓库表)) rollback
--更正 create trigger tri_name on 职工表 for insert ,update as if exists(select 1 from inserted where left(职工号,6) not in (select 仓库号 from 仓库表)) rollback
create trigger tr_test on 职工表 for insert,update as if not exists(select 1 from inserted a join 仓库表 b on a.职工号 like b.仓库号+'[0-9][0-9]') begin raiserror('您输入的职工号不符规范,请重新输入!',16,1) rollback end go
create trigger tr_test on职工表 for insert,update as if not exists(select 1 from inserted a join 仓库表 b on a.职工表 like b.仓库号+'[0-9][0-9]') begin raiseeeor('你输入的职工号不符合规范,请重新输入!',16,1) rollback end go
for insert ,update
as
if exists(select 1
from 职工表
where left(职工号,6) not in (select 仓库号
from 仓库表))
rollback
create trigger tri_name on 职工表
for insert ,update
as
if exists(select 1
from inserted
where left(职工号,6) not in (select 仓库号
from 仓库表))
rollback
for insert,update
as
if not exists(select 1 from inserted a join 仓库表 b on a.职工号 like b.仓库号+'[0-9][0-9]')
begin
raiserror('您输入的职工号不符规范,请重新输入!',16,1)
rollback
end
go
for insert,update
as
if not exists(select 1 from inserted a join 仓库表 b on a.职工表 like b.仓库号+'[0-9][0-9]')
begin
raiseeeor('你输入的职工号不符合规范,请重新输入!',16,1)
rollback
end
go