Difference between Triggers and Stored Procedure
Answer Posted / naveen jindal
trigger fired implicitely that is when ever events like
insert/update/delete commands.
Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the different types of collation sensitivity?
Define tool Manage Statistics in SQL Server 2000 query ?
Do you know the cursor optimization tips?
How the authentication mode can be changed?
Difference between report and query parameter. Why do we need different type of parameter?
What is a View ? Can we insert, Update and delete a view?
How secure is sql server database?
What is the query and subquery?
What is the need for group functions in sql?
Explain throw statement in sql server 2008?
What is PROJECTION Operation?
What is an execution plan?
What is 3nf normalization?
Is truncate autocommit?
What is the recovery model?