Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72595 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / madhu prakash p
sp and trigger are both predefined set of sql statements
we can pass the arguments for sp but we cant pass the
arguments for triggers.
trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.
But in the stored procedures u must call explicitly.
| Is This Answer Correct ? | 43 Yes | 9 No |
Post New Answer View All Answers
Do you have any idea about the tcl commands?
What is partition in sql server?
What is sql server database?
What are different backups available in sql server?
How to identify current user in ssrs report?
What is difference between index seek vs. Index scan?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is data source object?
Can a trigger be created on a view?
Explain in brief how sql server enhances scalability of the database system?
Why do we use trigger?
Where are stored procedures in sql server?
How do you delete duplicate rows in sql server?
What are the different types of lock modes in sql server 2000?
How do I find information about the install locations for the various instances running on a computer?
