Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72711 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / vikas sinha
1)Stored Procedure can call.but trigger is automatically
invoked when action defined in trigger is done.
2)Stored procedure can not be inactive.but trigger can be
active and inactive.
3)Stored Procedure may or may not reture a value.but
trigger will not return a value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can the “if update (colname)” statement be used in a delete trigger?
What is transaction server auto commit?
What are the restrictions while creating batches in sql server?
What is model database? : SQL Server Architecture
Explain few examples of RDBMS?
how can a database be repaired? : Sql server administration
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is join query?
Explain stored procedure?
How to create a new login name in ms sql server?
Why do we use non clustered index?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is difference between unique and primary key?
What is mapping schema?
What are the new features of sql server 2012 reporting service?
