Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73477 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / ajay panchal
Triggers are automatically run but stored procedures are not automatically run and they have to be called explicitly by the user.
we can write a stored procedure within a trigger but cannot write a trigger within a stored procedure.
Trigger is attached to table or view and is fired only when an INSERT, UPDATE, and/or DELETE occurs, while a stored procedure executes at any time when it is called.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to execute the cursor queries with "open" statements?
How do I open a .db file?
Explain the relational database management system (rdbms)?
What are key constraints?
What is co-related sub query?
What are user-defined functions (udfs) in sql server?
What are the new features of sql server 2008 r2 reporting service?
What is the optimization being performed in oracle and SQL Server?
Can you explain what are various ways to enhance the ssrs report?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What command would you use to create an index?
What is rs.exe utility?
How can I track the changes or identify the latest insert-update-delete from a table?
How to receive returning result from a query?
What are the advantages dts has over bcp?
