Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2005
>>>>>Do you want to have a trigger firing when a new column is added?
>>>>Yes
>>>> In SQL Server 2005 you need to look at DDL triggers.
>>>>Why?
>>>>
>>>>Viv
>>>>
>>>>
>>>Why not? DDL triggers are supposed to fire when the structure changes - looks like your case.
>>No - structure doesn't change. It's just an INSERT into the ProductFileColumns table.
>>When that happens I need to add a record in ProductFileData for each existing row using the Id of the newly inserted column.
>
>Aha, when what seems to be a problem? Just write a simple AFTER INSERT trigger.
As per the original post I don't know how to do this in the most efficient way. Care to post some code?
Best,
Viv
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement