Answer / rishi kumar

Constraint is used for column
Trigger is used for table

Answer / sairam

Both will be used to implement business rules.

Constraints will do memory location to table comparision.
where as triggers will do table to table comparision.
for this triggers will use magic tables(inserted,deleted).

In the order of precedence first Constraints next Triggers,
But performance wise triggers will give best performance
because table to table comparision is faster than memeory
location to table comparision.

Answer / 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.

Answer / harshad more

Constraints are great at maintaining database integrity for
database fields and relationships between database tables.

Triggers are great for checking past vs. current values and
making decisions based on that data.

In my experience, it is usually much more favorable to use
constraints when possible and leave the trickier business
and auditing logic for use in triggers.

Answer / nageswarao

Constraints are predefined business rules in which all the
organisations follow this constraints without any
modification.

trigger is a user defined business rule for which user is
responasible for logic for business rule

Answer / a.ganesh

constraints is predefined onc, but trigger can be defined
by user

Answer / vampire007

I dont' think Triggers are performanc wise more superior to
constraints. Constraints are isolated to table level
whereas triggers are flexible to do the validation on any
number of tables.

Answer / sairam singh

Both will be used to implement business rules.

Constraints will do memory location to table comparision.
where as triggers will do table to table comparision.
for this triggers will use magic tables(inserted,deleted).

In the order of precedence first Constraints next Triggers,
But performance wise triggers will give best performance
because table to table comparision is faster than memeory
location to table comparision.

Answer / malini paul

1.Constraint is a statement about a database that is always
true.Whereas triggers constrain what a transaction can do.

2.Constrain applies to existing data in the table and any
statement that manipulates the table.Whereas Trigger does
not apply to data loaded before the trigger was created.

Do you know the cursor types?

0 Answers  

What is the use of keyword with encryption.

0 Answers  

What is a database in ms sql server?

0 Answers  

Why do we use stored procedures in sql server?

0 Answers  

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

How do you open a cluster administrator?

0 Answers  

what is a live lock? : Sql server database administration

0 Answers  

What is delete query?

0 Answers  

How to modify the underlying query of an existing view?

0 Answers  

How data can be copied from one table to another table?

0 Answers  

Explain couple pf features of SQL server

2 Answers