what is the difference between trigger and storedprocedures
Answer Posted / poonam
Actually triger in action which is performed automatically
before or after a event occur and stored procedure is a
procedure which is executed when the it is called. Stored
procedure is module.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we use view in stored procedure?
What is a boolean in sql?
what are the different tables present in mysql? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Can a key be both primary and foreign?
what is a relationship and what are they? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
How is data stored in sql?
Can we use ddl statements in stored procedure sql server?
How do you update a table in sql?
write an sql query to find names of employee start with 'a'? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Can a view be mutating? If yes, then how?
How do I view a sql trace file?
What do you think about pl/sql?