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 are the 2 types of classifications of constraints in the sql server?
What is an execution plan? How would you view the execution plan?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Explain the creation and execution of a user-defined function in the sql server?
What is inner join in sql server joins?
What is the maximum length of an alert name?
Explain contrast amongst grouped and non-bunched records?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is a trigger what are the advantages of trigger?
What is sub-query in sql server?
How are the exceptions handled in sql server programming?
How to concatenate two character strings together?
Why truncate is ddl?
Write down the syntax and an example for create, rename and delete index?
What is DCL?