Constraints question

  • Thread starter Thread starter Woody Splawn
  • Start date Start date
W

Woody Splawn

I am using VS.net 2003 with SQL Server 2000 as the backend in a desktop
application. My question has to do with constraints.

The books seem to indicate that the best place to place a constraint is at
the table level in SQL Server 2000. Maybe so but if there is no way to get
data into SQL Server except through a VS application I wonder if it is
really necessary to place a constraint in the SQL Server table if you have
record or field validation in your code. What would be the purpose of that?

Anyone
 
You can input data from many sources. Query Analyzer, other ad-hoc
applications etc. Using the database to ensure integrity is the best
method. That way you will not have to try and figure out how that invalid
value showed up, most likely at the most inopportune moment.

Lloyd Sheen
 
Back
Top