触发器insert

Question

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [SPCUSRDATA]
   ON  [dbo].[Usr]
   AFTER INSERT
AS 
BEGIN
INSERT INTO dbo.SPCUserLog
           ([spcusrId]
           ,[usrCode]           
           ,[usrName]
           ,[colInfId]
           )
 SELECT 
            [usrId]
            [usrCode]           
           ,[usrName]
           ,[colInfId]
             
 FROM INSERTEDEND

Answer 1

少了个逗号
ALTER TRIGGER [SPCUSRDATA]
  ON [dbo].[Usr]
  AFTER INSERT
AS  
BEGIN
INSERT INTO dbo.SPCUserLog
  ([spcusrId]
  ,[usrCode]   
  ,[usrName]
  ,[colInfId]
  )
 SELECT  
  [usrId]
  ,[usrCode]   
  ,[usrName]
  ,[colInfId]