Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73467 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / madhu prakash p
sp and trigger are both predefined set of sql statements
we can pass the arguments for sp but we cant pass the
arguments for triggers.
trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.
But in the stored procedures u must call explicitly.
| Is This Answer Correct ? | 43 Yes | 9 No |
Post New Answer View All Answers
Does a specific recovery model need to be used for a replicated database? : sql server replication
Do you know what are the differences between lost updates and uncommitted dependencies?
How to transfer a table from one schema to another?
What happens when converting big values to integers?
What is candidate key with example?
What are the dmvs? : sql server database administration
Define master database?
Mention what are the core components of ssrs?
What is the difference between a view and a stored procedure?
Can you get second highest salary from the table?
How to update multiple rows with one update statement in ms sql server?
Is it true, that there is no difference between a rule and a check constraint?
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the joins in sql server? : sql server database administration
What is a transact-sql statement?
