Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36207 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 to rebuild indexes with alter index ... Rebuild?
What is the difference between a unique key and primary key?
How to filter out duplications in the returning rows in ms sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Explain triggers in sql?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is mapping schema?
Explain few examples of RDBMS?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What do you mean by an execution plan? How would you view it?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is a DBMS, query, SQL?
Explain where clause?
what is a check constraint?
What is abstracting periodical?
