Forum Replies Created

Viewing 15 posts - 316 through 330 (of 515 total)

  • RE: A Lifetime of Software

    paul.knibbs (5/10/2016)


    roger.plowman (5/10/2016)

    And when you retire and look back on your career, your victories will be yours, your failures will be yours, and no one else will ever know what...

  • RE: A Lifetime of Software

    I got bitten by the computer bug when I was 16 and aside from a few odd jobs to get me through college my career has been spent as a...

  • RE: More TRY_CONVERTing numbers

    When I run that select statement in SQL Server 2008 (10.0.5538) I get the error:

    SELECT TRY_CONVERT(NVARCHAR(1), 234523)

    Msg 195, Level 15, State 10, Line 1

    'NVARCHAR' is not a recognized built-in function...

  • RE: The Hidden Trigger

    Personally, I use three triggers on *almost every single table*--BUT 😀

    I only use them to create an audit log of insertions, deletions, updates and updates where I have to save...

  • RE: Naming Is Hard

    Ah, naming. Be it tables/columns/indexes/et al or variables/subs/functions/etc. there's no subject in the programming world that generates quite so much controversy.

    I think it's because it's so intensely personal. We've got...

  • RE: Would You Move For a Job?

    I'm older and settled, so no, I can't imagine any job I'd move for. I own a house, done a lot of custom remodeling to it (converted one room to...

  • RE: Do Less

    Preaching to the choir here. 😀

    My first programming was done on a 1962 vintage IBM 1130. In Fortran. On punch cards. (laughing)

    Yeah, you learn minimalism really fast when you have...

  • RE: A Sad Story about Upgrading to Windows 10

    djackson 22568 (3/15/2016)


    roger.plowman (3/15/2016)


    djackson 22568 (3/14/2016)


    umailedit (3/14/2016)


    Is anyone here worried about windows 10 spying on you? It sends stuff to microsoft even after you turn off all the spy...

  • RE: A Sad Story about Upgrading to Windows 10

    djackson 22568 (3/14/2016)


    umailedit (3/14/2016)


    Is anyone here worried about windows 10 spying on you? It sends stuff to microsoft even after you turn off all the spy options.

    I use my...

  • RE: Database Design Follies: NULL vs. NOT NULL

    ZZartin (3/11/2016)


    The problem with place holders like that is that you are using the same field for multiple purposes. TBD for example is not an addess it's a process...

  • RE: Database Design Follies: NULL vs. NOT NULL

    rstone (3/10/2016)


    In the logical design, the business logic might require handling missing data and reasons for missing data. Using tokens -2, -1 , 0, etc. is one way of handling...

  • RE: Database Design Follies: NULL vs. NOT NULL

    One final comment on this subject, and the reason I originally mentioned TBD, UNK, and N/A in the first place, is that null tells you ONE thing (data is missing)....

  • RE: Database Design Follies: NULL vs. NOT NULL

    ScottPletcher (3/1/2016)


    roger.plowman (3/1/2016)


    patrickmcginnis59 10839 (2/29/2016)


    roger.plowman (2/29/2016)


    I still don't see why relational tables can't have records for TBD, N/A, and UNK.

    If you need to know why a value is missing, you're...

  • RE: Database Design Follies: NULL vs. NOT NULL

    ZZartin (3/1/2016)


    roger.plowman (3/1/2016)


    patrickmcginnis59 10839 (2/29/2016)


    roger.plowman (2/29/2016)


    I still don't see why relational tables can't have records for TBD, N/A, and UNK.

    If you need to know why a value is missing, you're...

  • RE: Database Design Follies: NULL vs. NOT NULL

    patrickmcginnis59 10839 (2/29/2016)


    roger.plowman (2/29/2016)


    I still don't see why relational tables can't have records for TBD, N/A, and UNK.

    If you need to know why a value is missing, you're going to...

Viewing 15 posts - 316 through 330 (of 515 total)