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
Who is the owner of a schema in ms sql server?
What is a with(nolock)?
What are four major operators that can be used to combine conditions on a where clause?
What is report rendering ?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Tell me what is fill factor?
How you can change the database name in SQL SERVER?
What do you mean by subquery?
Why we should not use triggers?
Write an sql query for deleting duplicate rows?
Explain what is the difference between union and union all?
What do you mean by table and field in sql?
How is a full-text index updated?
What is the user of Primary key?
What is indexed view? How to create it?