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 are the different types of lock modes in sql server 2000?

0 Answers  

Can we insert data into a view?

0 Answers  

What is a materialized view?

3 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

How to run queries with sql server management studio express?

0 Answers  

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

Explain what is cte (common table expression)?

0 Answers  

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

Why do we use trigger?

0 Answers  

Explain what are magic tables in sql server?

0 Answers  

What’s the use of custom fields in report?

0 Answers  

What is pivot and unpivot?

0 Answers