Wht is the difference between stored procedure and trigger
Answer Posted / jerry joseph
Stored Procedures does not execute automatically
Triggers are a special type of Stored procedure which
executes automatically
Types of Triggers
- INSTEAD OF triggers
- AFTER Triggers
Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is msdb database? : SQL Server Architecture
In which files does sql server actually store data?
Can group by and orderby be used together?
What are data driven subscriptions?
What is named query? : sql server analysis services, ssas
Does sql server use java?
Can you explain what is indexed view? How to create it?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What happens if you delete a table that is used by a view?
What is the command used to check locks in microsoft sql server?
What is sparse columns of sql server 2008?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What are the pre-defined functions in the sql server?
What is difference between primary key and foreign key?