What is the difference between constraints and triggers?
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
How to fetch the next row from a cursor with a "fetch" statement?
What is stored in the mssqlsystemresource database? : sql server database administration
Indexes are updated automatically is the full-text index also updated automatically?
How can we check the sql server version?
What is the filtered index?
Is it possible to update the views? If yes, how, if not, why?
Explain how to integrate the ssrs reports in application?
Explain the advantages of merge replication?
What is the downside of using udf?
How to optimize stored procedure optimization?
What is a subquery in a select query statement in ms sql server?
optimization techinques
What are the different types of Indexes available in SQL Server?
Which is the main third-party tool used in sql server?
Why should one not prefix user stored procedures with ‘sp_’?