what is the difference between trigger and storedprocedures
Answer Posted / anbu
Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are sql objects?
what is uncommittable transactions? : Transact sql
Can a table have no primary key?
What is trigger types of trigger?
what are the advantages a stored procedure? : Sql dba
How does pl sql work?
Is time a data type in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is execute immediate?
What is rename in sql?
How many sql commands are there?
How many postgresql users are there, worldwide?
How do I view tables in sql developer?
Why we use stored procedure instead of query?