Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32209 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 are all different types of collation sensitivity?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the purpose of a secondary key?
What are the advantages of pl sql?
Explain the uses of control file.
What is a composite primary key?
does sql support programming? : Sql dba
What are different types of sql commands?
what is a table in a database ? : Sql dba
how many values can the set function of mysql take? : Sql dba
what is a materialized view? : Sql dba
What is compiled query?
Why trigger is used in sql?
Which is better varchar or nvarchar?
What is the difference between left join and right join?
