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 purpose of grouping data in a report?

0 Answers  

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

How to remove duplicate rows from table?

0 Answers  

Do you know data definition language, data control language and data manipulation language?

0 Answers  

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

What does nvl stand for?

0 Answers  

What are the types of indexing?

0 Answers  

What are the differences between decimal and float in ms sql server?

0 Answers  

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

How do you identify a foreign key?

0 Answers  

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

Explain differentiate between a having clause and a where clause?

0 Answers