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:
00886722
Views:
19
The Inserted and Deleted are tables and only way to get info from a table (besides cursors) is a query.
Also, did you consider posibility that DhCreation column could be change by UPDATE in which case QuartID column wouldn't be updated?

>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform