Difference between Triggers and Stored Procedure
- 23 Answers
- 69348 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
What is dirty page?
can an order by clause be used in a creation of a view?
What is autocommit mode in sql server?
What is nolock hint in sql server 2008
How to insert multiple rows with one insert statement in ms sql server?
Can we call future method from trigger?
What is the purpose of data source?
What are data resources?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is importing utility?
Differentiate between truncate vs delete in mssql?
what is the difference between Tabular and Matrix report?
What methods do you follow to protect from sql injection attack?
Explain datetime2 data type in sal server 2008?
What is database replication?
