what is the difference between trigger and storedprocedures

Answer Posted / anbu

Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql resultset?

527


Can cursors be part of a trigger body?

1116


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

671


How many sql core licenses do I need?

507


Explain clause in sql?

561






Why do we use procedures?

516


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

551


What are different types of keys?

521


How many tables can you join in sql?

528


Explain select statements in sql?

586


how can I make a script that can be bi-language (supports english, german)? : Sql dba

534


Explain about various levels of constraint.

521


What are the benefits of pl sql?

527


What is pl sql block structure?

542


Explain unique key in sql.

562