Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrent between store procedure and trigger
- 2 Answers
- 5363 Views
- I also Faced
- E-Mail Answers
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 happens when converting big values to integers?
How many partitions a clustered index has by default in sql server 2012?
What is data source document?
Explain about service Broker functions?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to use copy and concatenate commands in SQL?
what are database files and filegroups? : Sql server database administration
What are the different types of cursor?
How is sql server used?
what are user defined datatypes? : Sql server database administration
Give me any three differences between Truncate and Delete.
What part does database design plays a role in performance of an sql server-based application?
What are the grouping functions?
What are the different types of replication you can set up in sql server?
