what is the difference between trigger and storedprocedures

Answer Posted / narendra duby

triggers are invoked implicitly , while storedprocedures
are invoked explicitly.

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql keyword?

560


how many values can the set function of mysql take? : Sql dba

532


What is join view in sql?

514


What problem one might face while writing log information to a data-base table in pl/sql?

557


Is the primary key an index?

596






What are analytic functions in sql?

550


What types of commands can be executed in sql*plus?

551


What is audit logout in sql profiler?

589


Is delete faster than truncate?

547


Why is stored procedure faster than query?

492


What are types of joins?

535


Is left join inner or outer?

586


What is sql select statement?

504


what is “go” in t-sql? : Transact sql

601


Which is faster view or stored procedure?

503