Difference between Triggers and Stored Procedure
Answer Posted / thirupathi
1. Triggers are implicitly called by DB itself while SP has to be manually called by user.
2. SP can pass the parameters which is not a case with Triggers.
3. While creating a Trigger, triggering event n action has to be specified, which isn’t a case with SP.
4. A Trigger can call the specific SP in it but the reverse is not true.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the three different part of rdl file explain them?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Why is the need for data conversion transformations?
Is sql server free?
What is trigger explain with program?
What is row_number () and partition by in sql server?
Explain a join?
What is the boxing and unboxing concept in .net?
What command is used to create a database in the sql server and how?
How many databases instances are there in sql server 2000?
Which is faster statement or preparedstatement?
Explain Geometry datatype in sql server 2008 with example
difference between Clustered index and non clustered index ?
Explain the categories of stored procedure?
How to create an identity column?