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


Please Help Members By Posting Answers For Below Questions

What is the difference between in and between in sql?

575


What are the parts of a basic sql query?

513


what is a view? : Sql dba

636


What is an exception in pl/sql?

544


What are stored procedures in mysql?

561






What is a boolean in sql?

521


What programs use sql?

526


what is column? : Sql dba

569


What is on delete set null?

565


What are different types of tables in sql?

529


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

519


How to write a query to show the details of a student from students table whose

542


what is acid property in database? : Sql dba

560


Can we use commit inside a trigger?

525


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

551