帮忙看看这个到底哪里错了啊?

Question

这个是我写的第一个,,CREATE TRIGGER [user2user] ON [dbo].[oblog_user] 
AFTER INSERT
AS
BEGIN
insert into [pass_user] ([username],[password],[truepassword],[sex],[adddate],[question],[answer],[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg]) values (inserted.username,inserted.password,inserted.truepassword,inserted.usersex,inserted.joindate,inserted.userquesion,inserted,inserted.useranswer,inserted.useremail,7,0,1,inserted.userlastip,1,1)
END
GO错误128 The name 'username' is not permitted in this context. Only constants, expressions,   or variables allowed here. Column names are not permitted.   

Answer 1

CREATE   TRIGGER   [user2user]   ON   [dbo].[oblog_user]   
AFTER   INSERT 
AS 
BEGIN 
insert   into   [pass_user]   ([username],[password],[truepassword],[sex],[adddate],[question],[answer],[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg])   values   (inserted.[username],inserted.password,inserted.truepassword,inserted.usersex,inserted.joindate,inserted.userquesion,inserted,inserted.useranswer,inserted.useremail,7,0,1,inserted.userlastip,1,1) 
END 
GO 

Answer 2

CREATE   TRIGGER   [user2user]   ON   [dbo].[oblog_user]   
AFTER   INSERT 
AS 
BEGIN 
insert   into   [pass_user]   ([username],[password],[truepassword],[sex],[adddate],[question],[answer],[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg])  
select inserted.username,inserted.password,inserted.truepassword,inserted.usersex,inserted.joindate,inserted.userquesion,inserted,inserted.useranswer,inserted.useremail,7,0,1,inserted.userlastip,1,1 from inserted 
END 
GO 

Answer 3

CREATE   TRIGGER   [user2user]   ON   [dbo].[oblog_user]   
AFTER   INSERT 
AS 
BEGIN 
insert   into   [pass_user]   ([username],[password],[truepassword],[sex],[adddate],[question],[answer],[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg])   select inserted.[username],inserted.password,inserted.truepassword,inserted.usersex,inserted.joindate,inserted.userquesion,inserted,inserted.useranswer,inserted.useremail,7,0,1,inserted.userlastip,1,1
from inserted
END 
GO 

Answer 4

CREATE   TRIGGER   [user2user]   ON   [dbo].[oblog_user]   
AFTER   INSERT 
AS 
BEGIN 
insert into [pass_user] ([username],[password],[truepassword],[sex],[adddate],[question],[answer],[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg])   select inserted.[username],inserted.password,inserted.truepassword,inserted.usersex,inserted.joindate,inserted.userquesion,inserted,inserted.useranswer,inserted.useremail,7,0,1,inserted.userlastip,1,1
from inserted
END 
GO 

Answer 5

insert into 表（字段，字段） select inserted.字段，inserted.字段 from inserted--插入首行

Answer 6

CREATE   TRIGGER   [user2user]   ON   [dbo].[oblog_user]   
AFTER   INSERT 
AS 
BEGIN 
insert [pass_user]([username],[password],[truepassword],[sex],[adddate],[question],[answer],[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg])   
select [username],password, truepassword, usersex, joindate, userquesion, useranswer, useremail,7,0,1,inserted.userlastip,1,1
from inserted  
END 
GO 

Answer 7

CREATE   TRIGGER   [user2user]   ON   [dbo].[oblog_user]   
AFTER   INSERT 
AS 
BEGIN 
insert [pass_user]([username],[password],[truepassword],[sex],[adddate],[question],[answer]
,[useremail],[user_level],[user_isbest],[user_classid],[regip],[newbie],[isdigg])   
select [username],password, truepassword, usersex, joindate, userquesion, useranswer
, useremail,7,0,1,inserted.userlastip,1,1
from inserted  
END 
GO