Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-06 : 08:26:13
|
| tamilan writes "I have 5 tables. Whenever there is any updation in any table, I have to get the name of the table and column(which is updated, not all columns). (ie. updated table name & its updated column names,its values and its old values)Thank you.." |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-06 : 08:27:29
|
use after update triggerand COLUMNS_UPDATED() or UPDATE (columnName)and pseudo tables - inserted: new values - deleted: old valuesGo with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
SQL Server: Getting only updated fileds