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
How many aggregate functions are available there in sql?
How to change the order of columns in Oracle SQL Plus ?
What is trigger in flip flop?
How to run sql statements with oracle sql developer?
What is use of package in pl sql?
What is meant by cursor in sql?
Can we enter data in a table in design view?
Who developed sql?
What are the sql versions?
What are the different ddl commands in sql?
What does cursor do in sql?
How do I remove all records from a table?
What is the sql query to display the current date?
How do I view an execution plan in sql?
What is the difference between having clause and where clause?