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 cartesian join in sql?
What is java sql connection?
What is sql engine in oracle?
What is trigger in pl sql with examples?
what is a stored procedure? : Sql dba
What is sql clause?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do you go back in sql?
What is transaction control language (tcl)?
Is pl sql a scripting language?
Can a foreign key be a duplicate?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What are three advantages to using sql?
What is the order of sql select?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba