Difference between Triggers and Stored Procedure
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 are the core components of SSRS?
What is the main difference between ‘between’ and ‘in’ condition operators?
How to return the second 5 rows in ms sql server?
What is a non clustered primary key?
what stored procedure can you use to display the current processes? : Sql server administration
Explain logical operators in sql server?
What are .mdf files?
What is a trigger in sql server?
Do comments need to go in a special place in sql server 2005?
How to execute multiple stored procedures at one time in sql server?
How to drop an existing table?
How to find table changes in sql server?
Can you explain different types of joins?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?