Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
>>Is there a way to know which trigger called my SP? Update,Delete,New? Or is the only way to query the Insert and Delete tables and determine from there record counts?
>
>I don't think there's any way without passing some info from the trigger.
>
>BTW, are the deleted and inserted tables visible to a stored procedure that is called from within a trigger?
According to the MS-SQL Server self study training course I have they are.
>Also, are you sure that you want to call a stored procedure from within the trigger? Remember that a trigger will fire no matter how many rows were affected by the query.
>
>-Mike
Yep... that's what I need. Thanks for the help.
BOb
Précédent
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