What is the difference between constraints and triggers?
- 9 Answers
- 34884 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 are various aggregate functions that are available?
How can we delete Duplicate row in table?
What do we need queues in sql service broker?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
List out the differences between global and local temp tables in sql server?
Why olap is used?
What do you understand by coalesce in sql server?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is indexing explain it with an example?
What is merge join?
How to include text values in sql statements?
How to link tables in sql server?
Explain the categories of stored procedure?
What is the new security features added in sql server 2016? : sql server security
What is user-defined scalar function?
