what is the difference between trigger and storedprocedures
Answer Posted / nancy
BASIC DIFFERENCE IS trigger is automatically executed without an action required by a user where as stored procedure needs to be explicitly invoked...
a database TRIGGER ia a STORED PROCEDURE that is fired when an insert,update or deletestatements is issued against the associate table.a trigger is fired whwn database related event occurs....
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between sum and count in sql?
what are the different type of normalization? : Sql dba
What is dml with example?
What are string functions in sql?
What is a dirty read sql?
Write a unique difference between a function and a stored procedure.
What are the disadvantages of file system?
What is cross join sql?
Is sql better than excel?
What are stuff and replace function?
what is single byte over head in oracle..?
What is a composite primary key?
What is procedure and function?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How do you rename a table in sql?