求触发器的SQL.....

Question

CREATE Trigger [Insert_GameChat] ON dbo.userinfo
FOR INSERT
AS
Begin
Insert jgame_user(userid,username,[password],email,amoney) Select [id],uid,pwd,email,coin from Inserted
Insert vuserinfo(uid,userid,[password],privateemail,sex) 
        Select I.[id]
               ,I.uid
               ,I.pwd
               ,I.email 
               ,(case when t.sex='男' then 1 else 2 end)
        from Inserted I
        join table2 t on I.userid=t.userid
End

Answer 1

关联字段看错了CREATE Trigger [Insert_GameChat] ON dbo.userinfo
FOR INSERT
AS
Begin
Insert jgame_user(userid,username,[password],email,amoney) Select [id],uid,pwd,email,coin from Inserted
Insert vuserinfo(uid,userid,[password],privateemail,sex) 
        Select I.[id]
               ,I.uid
               ,I.pwd
               ,I.email 
               ,(case when t.sex='男' then 1 else 2 end)
        from Inserted I
        join table2 t on I.id=t.userid
End