what is the difference between trigger and storedprocedures

Answer Posted / satish kumar

stored procedure are collections of T-sql statements and
they are pre complied staements,it not requiers any
complitation.

trigger are not pre complied statements , and they are
going to activate only when certain action takes place like
insert , update, delete,

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cartesian join in sql?

557


What is java sql connection?

510


What is sql engine in oracle?

519


What is trigger in pl sql with examples?

519


what is a stored procedure? : Sql dba

548






What is sql clause?

539


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

615


How do you go back in sql?

529


What is transaction control language (tcl)?

634


Is pl sql a scripting language?

588


Can a foreign key be a duplicate?

499


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

665


What are three advantages to using sql?

549


What is the order of sql select?

572


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

641