What is the difference between constraints and triggers?
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 to filter out duplications in the returning rows in ms sql server?
What is the significance of master, tempdb and model databases?
How can you append an identity column to a temporary table?
How can we remove orphan records from a table?
Is sql different from sql server?
Can you explain what are various ways to enhance the ssrs report?
What is the difference between composite index and covering index?
Tell me what are cursors and when they are useful?
What happens if the update subquery returns no rows in ms sql server?
Explain primary key, foreign key and unique key?
What is an indexing strategy?
What are the types of joins in sql?
What is the cartesian product of the table?
Is oracle faster than sql server?
What command is used to delete a table from the database in the sql server and how?