sql server - The multi-part identifier "inserted.Id" could not be bound while creating trigger -

i trying create trigger on table in sql server 2012, giving error below

"the multi-part identifier "inserted.id" not bound",

the query executing is

create trigger dbo.[tr_t_documents_insertupdatedelete] on   dbo.[t_documents] after insert, update, delete begin       update dbo.[t_documents]     set dbo.[t_documents].[updatedat] = convert(datetimeoffset, sysutcdatetime())              inserted     inserted.[id] = dbo.[t_documents].[id] end 

the same executing in sql server 2014.

can me why happening in sql server 2012?

this due collation have database. in case, using case sensitive collation, table names need consistently. virtual trigger tables, these need in upper case, example:

create trigger dbo.[tr_t_documents_insertupdatedelete] on   dbo.[t_documents] after insert, update, delete begin       update dbo.[t_documents]     set dbo.[t_documents].[updatedat] = convert(datetimeoffset, sysutcdatetime())              inserted     inserted.[id] = dbo.[t_documents].[id]     --    ^^^^^^^^     --      this! end