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
Explain the properties of a relational table?
Describe triggers features and limitations?
What is the purpose of optimization?
How many types of schemas are there?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How many levels of sp nesting is possible?
Is it ok to shrink transaction log?
Explain what is use of dbcc commands?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How can I create a new template for import ? : sql server management studio
Define union, union all, minus, intersect?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Mention the different types of triggers?
What are “lost updates”?