Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Assigning values to a column with a UDF
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00886693
Message ID:
00886711
Views:
12
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
Map
View

Click here to load this message in the networking platform