create trigger 名 on 表
for insert
as
if exists(Select * from 表 where 用户代码 in (Select 用户代码 from inserted))
begin
rollback tran
raiserror('用户名重复',16,-1)
end
for insert
as
if exists(Select * from 表 where 用户代码 in (Select 用户代码 from inserted))
begin
rollback tran
raiserror('用户名重复',16,-1)
end
INSTEAD OF INSERT
AS
BEGIN
if exists(select 1 from inserted where 用户名 in (select 用户名 from 表))
begin
..........这里是触发代码
end
INSERT 表 SELECT * FROM inserted
END