what is diffrent between store procedure and trigger
Answer Posted / vandana chand
Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is an execution plan?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Define union, union all, minus, intersect?
Do you know sql server 2008 backup compression?
What is the correct order of the logical query processing phases?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is a with(nolock)?
What is the maximum size of a row in sql server?
How to create dbo table in sql server?
what are the different stages of Report Processing?
What is difference between count (*) and count 1?
Explain what is row_number function?
What is a primary index?
Explain four layers of abstraction microsoft architectured?
Define constraints and give an example of their use?