我的触发器到底错在哪儿,第一次写!

Question

CREATE trigger up_st on st_info
after insert,update
as
declare @user_number nvarchar(50),@user_testnumber nvarchar(50),@user_name nvarchar(255),@user_idnumber nvarchar(50),@user_zhiju nvarchar(20),@user_class nvarchar(20)
select @user_number =user_number from inserted
select @user_testnumber=user_testnumber from inserted
select @user_name=user_name from inserted
select @user_idnumber=user_idnumber from inserted
select @user_zhiju=user_zhiju from inserted
select @user_class=user_class from inserted
if not  exists(select user_name=@user_name from user_dict where user_number=@user_number)
insert into user_dict
select user_number,user_testnumber,user_name,user_idnumber,user_zhiju,user_class  from inserted
else
update user_dict
set user_testnumber=@user_testnumber
,user_name=@user_name
,user_idnumber=@user_idnumber
,user_zhiju=@user_zhiju
,user_class=@user_class

Answer 1

谢谢,原来是这样啊,谢谢,我太马虎了!