触发器insert
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 INSERTED

END



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