触发器的最后一行的")"附近有什么问题??(在线等)

[平台想钱想疯了]

CREATE TRIGGER [INSERTED_RECORD] ON [dbo].[TEST]
FOR INSERT
AS
BEGIN
DECLARE @ID INT
DECLARE @CHAR_F_NAME VARCHAR(20)
DECLARE @CHAR_L_NAME VARCHAR(20)
DECLARE @CHAR_QQ VARCHAR(20)
SET @ID=(SELECT ID FROM INSERTED)
SET @CHAR_F_NAME=(SELECT F_NAME FROM INSERTED)
SET @CHAR_L_NAME=(SELECT L_NAME FROM INSERTED)
SET @CHAR_QQ=(SELECT QQ FROM INSERTED)

INSERT INTO TEST1 VALUES(@ID,@CHAR_F_NAME,@CHAR_L_NAME,@CHAR_QQ)

[pbsql]

只有BEGIN没有END

[zjcxc]

try:
CREATE TRIGGER [INSERTED_RECORD] ON [dbo].[TEST]
FOR INSERT
AS
BEGIN
DECLARE @ID INT
DECLARE @CHAR_F_NAME VARCHAR(20)
DECLARE @CHAR_L_NAME VARCHAR(20)
DECLARE @CHAR_QQ VARCHAR(20)
SELECTT @ID=ID
,@CHAR_F_NAME=F_NAME
,@CHAR_L_NAME=L_NAME
,@CHAR_QQ=QQ
FROM INSERTED

INSERT INTO TEST1 VALUES(@ID,@CHAR_F_NAME,@CHAR_L_NAME,@CHAR_QQ)

或:
CREATE TRIGGER [INSERTED_RECORD] ON [dbo].[TEST]
FOR INSERT
AS
INSERT INTO TEST1
SELECTT ID,F_NAME,L_NAME,QQ
FROM INSERTED

[zjcxc]

要改一下
CREATE TRIGGER [INSERTED_RECORD] ON [dbo].[TEST]
FOR INSERT
AS
DECLARE @ID INT
DECLARE @CHAR_F_NAME VARCHAR(20)
DECLARE @CHAR_L_NAME VARCHAR(20)
DECLARE @CHAR_QQ VARCHAR(20)
SELECTT @ID=ID
,@CHAR_F_NAME=F_NAME
,@CHAR_L_NAME=L_NAME
,@CHAR_QQ=QQ
FROM INSERTED

INSERT INTO TEST1 VALUES(@ID,@CHAR_F_NAME,@CHAR_L_NAME,@CHAR_QQ)

[zjcxc]

你原来的触发器除没有写end外,
如果同时插入多条记录,也会出错

[平台想钱想疯了]

谢谢各位了.分值少了点不好意思,下次我出多一点.

[平台想钱想疯了]

对了,

你原来的触发器除没有写end外,
如果同时插入多条记录,也会出错


那我要怎么改??