Dinesh Kumar
asked on
instead of trigger on view
Hi experts,
1) Can I insert data into base table using instead of trigger on view?
2) how I will pass values to instead of trigger on view.
I see that whenever there are more than one tables are involved in view than we can update using instead of trigger on view.
3) will instead of trigger always fire if set on view?
Thanks
meetDinesh
1) Can I insert data into base table using instead of trigger on view?
2) how I will pass values to instead of trigger on view.
I see that whenever there are more than one tables are involved in view than we can update using instead of trigger on view.
3) will instead of trigger always fire if set on view?
Thanks
meetDinesh
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Why do I use instead of Trigger on views when I know I can directly fire an insert query using view?
what is the main use of writing sql query in view other than security?
when instead of trigger on view gets executed?