what is the difference between trigger and storedprocedures
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
What is a column in a table?
What is pl sql quora?
What is the use of count (*) in sql?
What is the purpose of primary key?
what is the difference between delete and truncate commands? : Sql dba
What pl/sql package consists of?
How do I run a sql trace?
Is like operator in sql case sensitive?
What does the file extension accdb stand for?
Does sql profiler affect performance?
how to drop an existing index in mysql? : Sql dba
What is the difference between the conventional and direct path loads? : aql loader
What is sqlerrm?
What is an example of translating a date into julian format?
How do you break a loop in pl sql?