ChrisM@Work (7/25/2016)
Alan.B (7/25/2016)
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,It's fine! I've seen NVARCHAR for gender today. N'F' and N'M'. Really...
I've seen large systems (like National Statistics) go bonkers when those values have changed and once had to reject the proposal of "CM", "CF" and "UK", "Changed to Male", "Changed to Female" and "UnKnown" respectfully. Needless to say those were NVARCHAR(50) coming from an old MS-Access application:pinch:
😎