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 |
|
Mohansoft
Starting Member
6 Posts |
 Posted - 2005-09-05 : 11:10:54
|
| What are instead of triggers and how can we use them to make dml operations in a view.If we make dml operations in a view that is a result of many join only the base table gets affected.If it is so why?D.Mohan Raj |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-05 : 11:15:41
|
have you read BOL = Books Online = sql serve helpunder "triggers, Instead of"??Go with the flow & have fun! Else fight the flow  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-05 : 15:30:35
|
| "What are instead of triggers"They fire instead of an UPDATE or INSERT"and how can we use them to make dml operations in a view""If the VIEW comprises multiple tables (or even if it doesn't, but it covers a table in another database which has a computed column or some other ghastly construct) then an instead of trigger can be used to control how the UPDATE/INSERT is performed."If we make dml operations in a view that is a result of many join only the base table gets affected. If it is so why?"How would you suggest that an UPDATE/INSERT could safely be performed in such circumstances without explicit coding?Kristen |
|
|
|
|
|
|
Instead of Triggers