Jeff Moden (1/7/2010)
bear in a box (6/24/2009)
...but this assumes one knows very field in the table has been allowed or not allowed nulls. this is not the case which is why the issue comes up during actual.As a developer, you'd better know what the data in the table is and whether or not a column can take a NULL or not... it's part of the job. It only takes a second or two to find out.
I am also the end user of my systems handling sales data of close to a billion in sales per year. There are 3 departments who are the internal customers of these data. But database is just 1 of my 5 hats in IT, even if I have two delegates for some of the work.
My concentration flips between making our IT close to business then being IT technical to get things going. Right now, our AV is not getting updated, part of the wealth of bugs which is the trademark of a well-known vendor. I have been batting at it all day yesterday.
Now, this morning, I will be shifting to data processing again - another ad hoc request from sales. From where I am, it is very easy to fall into the same problem solved a 2 years back.