General information
Forum:
Microsoft SQL Server
Category:
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... :)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only