October 18, 2011 at 2:35 pm
Britt Cluff (10/17/2011)
Thanks for the question. I was pretty sure the check constraint would allow the NULL value.
Ditto x 2. Just wanted to add that some Neanderthals (e.g. my favorite server :-)) are still running a version of SQL Server which won't accept type "date" (unless it's been defined by a fellow Nean.Man) -- could it hurt in these type of questions to write code which will work in older-than-latest versions (e.g. in this case, to use type "datetime")? Thanks.
October 21, 2011 at 1:18 am
The date datatype was added in SQL2008, so question might have been been better if it used the ubiquitous datetime datatype instead (i.e. viable on SQL2000, 2005 etc). No biggie!
October 26, 2011 at 12:10 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply