Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36893 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
What is the optimization being performed in oracle and SQL Server?
Is truncate autocommit?
Can we use trigger new in before insert?
What is sql language?
What is the Main Difference between ACCESS and SQL SERVER?
How do I setup a local sql server database?
How will you know when statistics on a table are obsolete?
What is the difference between functions and stored procedures?
What is the use of custom fields in report?
What is a virtual table in sql?
what is unique and xaml nonclustered index
Name few of the dcl commands in sql?
Define the one-to-one relationship while designing tables.
How to write a query with an inner join in ms sql server?
If a table does not have a unique index, can a cursor be opened on it?
