Difference between Triggers and Stored Procedure

Answer Posted / madhu prakash p

sp and trigger are both predefined set of sql statements

we can pass the arguments for sp but we cant pass the
arguments for triggers.

trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.

But in the stored procedures u must call explicitly.

Is This Answer Correct ?    43 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sql servers linked to other servers?

763


What are the restraints imposed on the table design by a merge replication?

813


Do you know what is blocking?

749


what are candidate key, alternate key and composite key? : Sql server database administration

701


What is stored procedures?

734


What are the kinds of subquery?

744


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

794


What is a data source or ds? : sql server analysis services, ssas

790


what are acid properties? : Sql server database administration

697


How to retrieve error messages using mssql_get_last_message()?

763


Explain how to send email from sql database?

759


How to change the system date and time from SQL Plus Terminal ?

901


What is open database communication (odbc)?

775


What are a scheduled jobs?

728


Can a trigger be created on a view?

760