Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
As the very first qeustion " The smarter way to update row that just inserted?" I'm not good in T-SQL, so If I use update in Sp inside Trigger that just Update or Insert data, I want it update UserName and LastUpdate column. Just that I've to write code in Trigger in every table, then when I have to update 1 or more column I've to edit all trigger of every table... So I want to call Sp inside Trigger to update "Table"
But I'm not sure about how to specify which row (That just inserted) to update
I've to use "Where" to specify row that just update. Can you give some T-SQL Sproc for example to use inside Trigger. Please... :)
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