Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The smarter way to update row that just inserted?
Message
From
15/12/2000 05:09:30
 
 
To
14/12/2000 10:12:05
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00452399
Message ID:
00453832
Views:
25
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... :)
Previous
Reply
Map
View

Click here to load this message in the networking platform