Thanks for your comments. Please allow me to explain the reason I wrote the article the way I did:

The examples I used for the BirthDate constraint are based on the assumtion that you are talking about an employee table. At the time I wrote this article it seemed extremely unlikely to have an employee that was born before 1900 or after 1999.

Your trust of client-side applications depends on who controls the building and testing of those applications. If you trust those people then you will not need to use constraints. If you don't trust them then using constraints will give you the assurance you need.

In my article I failed to specify the data type for the columns used in the examples. They were run on the NorthWind database and for the BirthDate the data type is datetime.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.