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
what is a mixed extent? : Sql server administration
How can you list all the table constraints in a database?
What are the types of database recovery models?
Define constraints and give an example of their use?
what is normalization? Explain different levels of normalization? : Sql server database administration
How many database files are there in sql server 2000?what are they?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is ssl in sql server?
What are temporal tables in sql server 2016?
How to transfer an existing table from one schema to another schema in ms sql server?
What is a linked server in sql server?
What is mean by candidate key?
How does recursive cte works in sql server?
What is the difference between a "where" clause and a "having" clause?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?