Trigger will fire when the condition arises but the stored procedure will

what is the difference between trigger and storedprocedures

Question Posted / anbu

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

Please Help Members By Posting Answers For Below Questions

What is bulk collect in pl sql?

1044

what is an alias command? : Sql dba

1028

What is cursor and its types?

1016

what is bcp? When does it used? : Sql dba

947

Is left join and outer join same?

1022

How would you pass hints to the sql processor?

943

What is composite primary key in sql?

952

What are the disadvantages of not performing database normalization?

1119

what is 'mysqlimport'? : Sql dba

989

How do sql databases work?

965

Is sqlexception checked or unchecked?

927

Explain the difference between 'between' & 'and' operators in sql

963

How do you optimize a query?

950

how to include character strings in sql statements? : Sql dba

1018

What is query execution plan in sql?

1142