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:
00886715
Views:
18
I got it:


CREATE TRIGGER TR_TRANSACTION_INSERT ON [dbo].[Transaction]
INSTEAD OF INSERT
AS

BEGIN

Declare @Quart int, @DhCreation datetime

SELECT @DhCreation = DhCreation FROM INSERTED
SET @Quart = dbo.GetQuartID(@DhCreation)


INSERT INTO [Transaction] (DhCreation, QuartID) values (@DhCreation,@Quart)

END



===============

IT SEEMS that a SELECT is required and that the inserted by itself is not valid..


Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform