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.

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

What are clustered and non-clustered index?

0 Answers  

How many types of Outer Joins?What are they?

1 Answers  

What is a mutating table error and how can you get around it?

0 Answers  

Explain the difference between functions and stored procedures in sql server?

0 Answers  

Explain the rules for designing files and file groups in sql server?

0 Answers  

What is normalization?

9 Answers  

What are sql server functions?

0 Answers  

How can I create a table from another table without copying any values from the old table?

3 Answers  

What is conditional split?

0 Answers