• JustMarie (7/25/2016)


    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...

    First let me state that I cannot change this. Yet.

    But I'm dealing with NVARCHAR(1) fields in a particular data set. Where the data can never be unicode.

    And can never be NULL, right?

    I love designs like that.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events