Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The smarter way to update row that just inserted?
Message
De
15/12/2000 05:09:30
 
 
À
14/12/2000 10:12:05
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00452399
Message ID:
00453832
Vues:
26
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
Fil
Voir

Click here to load this message in the networking platform