what is the difference between trigger and storedprocedures
- 16 Answers
- 29391 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satish kumar
stored procedure are collections of T-sql statements and
they are pre complied staements,it not requiers any
complitation.
trigger are not pre complied statements , and they are
going to activate only when certain action takes place like
insert , update, delete,
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain select statements in sql?
what is a cursor? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What is orm in sql?
what is acid property in database? : Sql dba
How many row comparison operators are used while working with a subquery?
What is sql key?
What is cost in sql execution plan?
Does sql*plus also have a pl/sql engine?
What is an example of translating a date into julian format?
What is the use of sqlerrd 3?
What do you mean by stored procedures?
Define implicit and explicit cursors.
Mention what does plv msg allows you to do?
What is difference between stored function and application function?
