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.

What is the order in which the sql query is executed?

0 Answers  

What are entities and relationships?

0 Answers  

Explain nested join?

0 Answers  

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

What is the use of nvl work?

0 Answers  

What is table constraint?

0 Answers  

What is normalization and what are the different forms of normalizations?

2 Answers  

What is always encrypted?

0 Answers  

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

What is the default value of an integer data type in sql server 2005?

0 Answers  

Define compound operators?

0 Answers  

How to delete a login name in ms sql server?

0 Answers