I am trying to add a simple check constraint and for the life of me I cannot figure out why SQL isn't accepting it. All i want to do is something like the following:
[ColumnName] < '1/1/2000'
But SQL won't accept this. I have even tried many different variations, such as
([ColumnName] < CONVERT([smalldatetime], '1/1/2000', (0)))
What am I completely brain farting on with this?
Author - Professional SQL Server 2005 XML