What is difference between Triggers and store procedure?

Answer Posted / vidit tyagi

triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of processing and explain each? : sql server analysis services, ssas

809


What is Command line parameters in PLSQL.?

659


How to configure and test odbc dsn settings?

665


What are Row versions of DataRow?

697


Write query to return all rows sql?

694






What is difference between joins and subqueries?

622


Explain syntax for disabling triggers?

606


What is the difference between a unique key and primary key?

586


How to find table changes in sql server?

753


What is difference between views and stored procedures?

604


What is a collation?

705


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

615


Can We Use Data-grids For Our Report In Ssrs?

153


How do I view a procedure in sql server?

628


Write the queries for commands like Create Table, Delete table, Drop Table etc.

698