what is the difference between trigger and storedprocedures
Answer Posted / sohail
Trigger and procedures are same but the substantial
difference is when they run.procedure is invoked explicitly
by the user and trigger is executed implicitly. another
diffrence is procedure cannot have the same name as table
name,funtion name or package name but trigger can have same
name as table name or procedure name.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
how to create a table index in mysql? : Sql dba
What is the use of pl/sql table?
how to write date and time literals? : Sql dba
Is subquery faster than join?
What is sql architecture?
How many sql databases can you have on one server?
What are tables and fields?
what are the differences between binary and varbinary? : Sql dba
What are sql indexes?
What are dml commands?
how to use myisamchk to check or repair myisam tables? : Sql dba
Is natural join same as inner join?
What is the use of index in hive?
what are integrity rules?
What is the file extension for sql database?