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
when is the use of update_statistics command? : Sql dba
Where do we use pl sql?
How to combine two stored procedures in sql?
What is rownum in sql?
How many tables can a sql database have?
How to use boolean type in select statement?
How do I count records in sql?
Which table is left in join?
How do you go back in sql?
what is user defined functions? : Sql dba
Explain isolation levels. : Transact sql
what is 'mysqlshow'? : Sql dba
What is pl/sql language case sensitive?
which tcp/ip port does sql server run on? : Sql dba
What is application trigger?