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 happens if null values are involved in arithmetic operations?
What are transactions in sql?
Define union, union all, minus, intersect?
Is mysql the same as sql server?
Do you know the different ddl commands in sql?
How do I trace a query in sql server?
What are the mathematical functions supported by sql server 2005?
What is @@error in sql?
What is unique key constraint?
How to create a large table with random data for index testing in ms sql server?
Indexes are updated automatically is the full-text index also updated automatically?
What are the steps to process a single select statement?
Tell me what do we need queues in sql service broker?
What is the command dbcc checkdb used for?
What does ss stand for sexually?