Difference between Triggers and Stored Procedure

Answer Posted / ram

Stored Procedures are called by the programmer wherever it
wants to fire but triggers fired automatically when
insert,delete,update occured. And triggers can be
implemented to tables & views only where as s.p used in the
database independently

Is This Answer Correct ?    135 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrieve error messages using odbc_errormsg()?

721


What the different types of Replication and why are they used?

719


What is normalization process?

793


What is difference between oltp and olap?

776


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

105






Explain can you implement data mining in ssrs?

122


What is dknf in normalization form?

725


Why can there be only one clustered index and not more than one?

730


What is exporting and importing utility?

771


Explain the difference between HTTP and HTTPS in database?

746


How do I create a stored procedure in dbml?

687


What is instead of dml trigger?

770


How to provide default values to function parameters?

762


What is identity?

761


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2261