what is the difference between trigger and storedprocedures
Answer Posted / srikanth
Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.
triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is datawarehouse? : Sql dba
What makes a good primary key?
What is sql table?
what is blob? : Sql dba
What is varray in pl sql?
What are triggers and its uses?
Why do we use procedures in pl sql?
What are different types of triggers?
Is it possible to pass parameters to triggers?
What is query optimization in sql?
How do I access sql anywhere database?
What are synonyms in sql?
What are the types of join and explain each?
What is a file delimiter?
how many ways to get the current time? : Sql dba