| |
GeekInterview.com > Interview Questions > Database
| Print | |
Question: What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger?
|
| May 05, 2007 12:50:26 |
#4 |
| vibha_kant |
Member Since: May 2007 Total Comments: 5 |
RE: What is the difference between a stored procedure ...
|
Mutating triggers :
I am not aware of mutating triggers in SQL Server. Per my knowledge only MySQL and Oracle throws this error. Coming back to the point, mutating trigger occurs when the table which fired the triggering event is being accessed in the body of the trigger code, directly or indirectly through a nested trigger or procedure etc. This is not allowed as the table could be in a middle of transaction. |
| |
Back To Question | |
