what is diffrent between store procedure and trigger
Answer Posted / sankar
1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.
2)We can call Trigger inside the store procedure. But
reverse is not possible.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is molap and its advantage? : sql server analysis services, ssas
What are the different methods available under sqlcommand class to access the data?
What is #table in sql server?
What is named query? : sql server analysis services, ssas
Explain what is analysis service repository?
Explain having clause?
What are the default system databases in sql server 2000?
What is user-defined multi-statement table-valued function?
Can we use pragma autonomous_transaction in trigger?
What is the difference between clustered and a non-clustered index?
How many triggers are possible per table?
What does COMMIT command do?
Is t sql the same as sql server?
What are null values in ms sql server?
What is trigger and different types of Triggers?