CHECK Constraints vs NULL values

Question

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 1

we set getdate() as default value for few of our date columns (not for all date columns), but never heard of keeping such high future date.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

SSCertifiable

Points: 5306

May 7, 2015 at 3:17 am

Nice explanation hugo

Bhushan Kulkarni SSCrazy Points: 2829 More actions · Answer 3

SSCrazy

Points: 2829

May 29, 2015 at 12:08 am

Good one, learned something new

simon.barnes Old Hand Points: 370 More actions · Answer 4

I actually assumed that the constraint would be fine, but untrusted. And thus just learnt that new constraints issue a check upon creation.

Cookies on SQLServerCentral