Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Assigning values to a column with a UDF
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00886693
Message ID:
00886711
Vues:
13
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 ????
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform