这是一个防止插入重复数据的触发器sql语句:
create TRIGGER notsameuser
ON user_pwd
instead of insert
as
BEGIN
insert user_pwd
select userId,userName,pwd,lastTime,userType
from inserted k
where not exists(select * from user_pwd where userName=k.userName or pwd=k.pwd)
END