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 the difference between in and between in sql?
What are the parts of a basic sql query?
what is a view? : Sql dba
What is an exception in pl/sql?
What are stored procedures in mysql?
What is a boolean in sql?
What programs use sql?
what is column? : Sql dba
What is on delete set null?
What are different types of tables in sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How to write a query to show the details of a student from students table whose
what is acid property in database? : Sql dba
Can we use commit inside a trigger?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?