Article Discussion: Constraints In Microsoft SQL Server 2000

Database constraints, database integrity, keys and constraints are explained with code and examples thoroughly in this article.&nbsp; Ensuring data integrity is emphasized as well. Protect your information investment by using these helpful tips and keys!&nbsp; <EM>"Moving the responsibility for data integrity into the database has been revolutionary to database management. Constraints in Microsoft SQL Server 2000 allow us to define the ways in which we can enforce the integrity of a database.&nbsp; Using constraints is preferred to using triggers, stored procedures, rules, and defaults, as a method of implementing data integrity rules."</EM>


Read the full article here: Constraints In Microsoft SQL Server 2000

If I use a constraint and the data is not formatted properly what type of error is produced? Does it trigger an exception (I am assuming c# in .NET)? What is the best way to handle data I/O from the DB if I use constraints?