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
what is timestamp in mysql? : Sql dba
Explain character-manipulation functions?
Explain the the update statement in sql?
What are the operators used in select statements?
Explain the difference between rename and alias?
What is sqlcommand?
Does sql require a server?
What is the difference between truncate and drop statements?
How many triggers can be applied to a table?
What is a common use of group by in sql?
Write a query to display the current date in sql?
What is nosql vs sql?
How to select unique records from a table?
Which one is better sql or oracle?
Are left and right joins the same?