Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36586 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to execute a stored procedure in ms sql server?
what is a mixed extent? : Sql server administration
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is the default fill factor value?
What is the meaning of sql server?
What does man by sql wildcard characters in sql server?
Define tempdb database?
What is an execution plan? When would you use it?
Where can you add custom error messages to sql server?
What is tempdb database? : SQL Server Architecture
How many types of database relationship in sql server?
How to list all dsn entries on your local machine using odbc_data_source()?
Explain the difference between clustered and non-clustered index?
Is resultset an interface?
