General information
Forum:
Microsoft SQL Server
New version, different problem:
CREATE TRIGGER TR_TRANSACTION_INSERT ON [dbo].[Transaction]
INSTEAD OF INSERT
AS
BEGIN
Declare @Quart int, @DhCreation datetime
SET @DhCreation = inserted.DhCreation
SET @Quart = dbo.GetQuartID(@DhCreation)
INSERT INTO [Transaction] (DhCreation, QuartID) values (@DhCreation,@Quart)
END
=================
I get:
The column prefix "inserted" does not match with a table or alias name used in the query...
I tought that inserted, updated, deleted was referring to the table being inserted, deleted, or updated to ????
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only