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 - 2002-02-25 : 08:59:19
|
| Ashish writes "The problem is : I have table x1 and i have to write a trigger on it so that i can find the type of query fired on it (insert, update or delete) and find if it was successful and populate the columns accordingly of other table say x2.Can anybody help me !!!!!" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-25 : 09:32:45
|
| Probably easiest to have 3 triggers update, insert, delete.Otherwise to find the operation look at inserted and deleted. For an update both will be populate for insert/delete the insertd/deleted only.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
trigger to find type of operation and whether it was successful