Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36489 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 options are available to audit login activity? : sql server security
What is subreport?
What is the use of stored procedure?
What is the query and subquery?
How to generate create procedure script on an existing stored procedure?
What is the Difference Between Primary and Foreign Key?
on line cluster can we make if yes tell me the procedure
How to update values in a table with update statements in ms sql server?
Can sql servers linked to other servers like oracle?
Explain the steps to use transact-sql cursor?
What happens to a statement batch if there is a compilation error?
Can we do dml on views?
What is a schema in ms sql server 2005?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What are some examples of schemas?
