Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36592 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Does full backup break log chain?
What is parameterized reports in ssrs ?
What is truncate table?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is a result set object returned by odbc_exec()?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
how can you attach more than 20 ldf files in sql server
What is the use of keyword with encryption. Create a store procedure with encryption?
What are the advantages of using a stored procedure?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What the different components of Replication and what is their use?
What is in place upgrade in sql server?
What is the difference between commit and rollback?
