Difference between Triggers and Stored Procedure
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
How to replace null values in expressions using isnull()?
Explain what is public role in sql server?
What is a raid and what are different types of raid configurations?
Can you explain the disadvantages/limitation of the cursor?
How to defragment table indexes?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is an inner join?
what is normalization? Explain different levels of normalization? : Sql server database administration
What are cascading parameters in ssrs reports?
Explain important index characteristics?
How do I delete a sql server database?
What is a join in sql?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Define self join in sql server joins?