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

How does stored procedure reduce network traffic?

542


Define select, insert, create, delete, update, drop keywords

596


what is the different between now() and current_date()? : Sql dba

522


What programs use sql?

523


What is difference sql and mysql?

529






What is cursor and why it is required?

551


What is a trigger word?

514


How many clustered indexes can be created on a table?

585


What does where 1 1 mean in sql?

541


discuss about myisam key cache. : Sql dba

561


What is foreign key in sql with example?

511


What is the difference between left join and right join?

500


What is record type in pl sql?

542


how to get help information from the server? : Sql dba

526


Is left join inner or outer?

583