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
Enlist the characteristics of pl/sql?
Can you upgrade sql express to full sql?
What is online transaction processing (oltp)?
How to select unique records from a table?
how does a local variable is defined using t-sql? : Transact sql
Explain the difference in execution of triggers and stored procedures?
Is the primary key an index?
What does count (*) do in sql?
What has stored procedures in sql?
What's the difference between a primary key and a clustered index?
What is a string data type in sql?
Can a procedure in a package be overloaded?
What is a primary key sql?
what are date and time data types? : Sql dba
What is difference between pl and sql?