Forum Replies Created

Viewing 15 posts - 136 through 150 (of 392 total)

  • RE: NULL quandry

    Phil Parkin - Thursday, January 18, 2018 11:16 AM

    Instead of this
    WHERE NOT ((@OldValue IS NULL AND @NewValue IS NULL) OR (@OldValue =...

  • RE: UPDATE() function in a trigger

    Jeff Moden - Thursday, January 18, 2018 7:47 AM

    Ah, be careful, Aaron... I had considered that when I reworked our audit...

  • RE: UPDATE() function in a trigger

    Thanks for all the replies.  I did find a solution that suited my needs.  I still generate a separate select statement for each column (I may look at the unpivot...

  • RE: SET the results

    Oh silly me! I was so focused on the whole principle that order is not guaranteed without an ORDER BY clause that I didn’t notice the use of SET instead...

  • RE: Singular or Plural

    richard.julian - Monday, December 11, 2017 1:43 PM

    I've used singular going on 27 years now, initially because that is what I first...

  • RE: Singular or Plural

    RonKyle - Monday, December 11, 2017 11:11 AM

    Aliases should be short but representative of the table is some manor. For...

  • RE: STRING_SPLIT with no delimiter

    Pretty slick! It took me a moment with the multiple casts but that was a slick trick.:smooooth:

  • RE: Singular or Plural

    Eric M Russell - Friday, December 8, 2017 2:12 PM

    Lynn Pettis - Friday, December 8, 2017 1:09...

  • RE: Singular or Plural

    Just to reiterate what some others have stated: Consistency is King!  Like with many other programming conventions, however it's done is not really as important as long as it's done...

  • RE: Start Fixing Your DB with Better Code

    Eric M Russell - Friday, November 17, 2017 6:58 AM

    The industry of SQL coding suffers from the same predicament as HTML; a...

  • RE: Start Fixing Your DB with Better Code

    RonKyle - Thursday, November 16, 2017 2:23 PM

    I don't think there's a bright shining line that can't be crossed.  But I...

  • RE: Start Fixing Your DB with Better Code

    RonKyle - Thursday, November 16, 2017 1:08 PM

    Agreed.  Thanks for the clarification.  It seemed like you might not have been in...

  • RE: Start Fixing Your DB with Better Code

    RonKyle - Thursday, November 16, 2017 12:53 PM

    rat's nest of stored procedures

    What do you mean by this?  My understanding is...

  • RE: Start Fixing Your DB with Better Code

    I am also in the very choir that's being preached to!! 😛

    I am a very big believer in doing it right the first time because there never seems...

  • RE: Introverted vs Extroverted

    As others have pointed out, there is no definitive line between an introvert and extrovert.  If I had to classify myself I would have to say that I'm a social...

Viewing 15 posts - 136 through 150 (of 392 total)