Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36600 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / amit upadhyay
DIFFRENCE BETWEEN CONSTRAINTS AND TRIGERS
CONSTRAINTS :- IS USED FOR ENFORCING THE DATA INTEGRITY.
TRIGGER :- SQL SERVER AUTOMATICALLY FIRED TRIGGER
WHENEVER WE DO DML OPERATION.THIS IS ALSO
USED FOR ENFORCING THE DATA INTEGRITY.
WHENEVER TRIGGER IS FIRED TWO MAGIC TABLE
ARE CREATED.ONE IS INSETRTED AND SECOND
IS DELETED.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
How can i Relate Tables in SSIS
What is transaction server explicit transaction?
What does Master database contains?
Define full outer join?
Do you know what is lock escalation?
What is normalization according to you and explain its different levels?
Do you know what are the reporting services components?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
How to drop an existing user defined function in ms sql server?
If user is owning any SQL Objects, can we drop that user
What is the difference between clustered and non-clustered indexes in ms sql server?
What are user-defined functions (udfs) in sql server?
What is Cross Join and in which scenario do we use Cross Join?
What is de-normalization in sql database administration? Give examples?
SQL Server Architecture ?
