Forum Replies Created

Viewing 15 posts - 16 through 30 (of 54 total)

  • RE: Converting Binary Numbers To Hex

    Solomon Rutzky - Tuesday, November 27, 2018 2:54 PM

    I was guessing it would be INT as that is the easiest, most...

    November 27, 2018 at 3:05 pm

    #2014727

  • RE: Converting Binary Numbers To Hex

    Solomon Rutzky - Tuesday, November 27, 2018 9:38 AM

    • and not sure how much this helps, but I changed the "NULL" to "0"...

    November 27, 2018 at 11:02 am

    #2014703

  • RE: The funny WHERE

    Eirikur Eiriksson - Sunday, November 25, 2018 8:26 AM

    Jonathan AC Roberts - Sunday, November 25, 2018 8:02...

    November 26, 2018 at 11:30 am

    #2014556

  • RE: Deterministic functions

    Steve Jones - SSC Editor - Monday, November 19, 2018 9:38 AM

    It's not listed in BOL. Perhaps because there could be some...

    November 19, 2018 at 3:30 pm

    #2014042

  • RE: Backup to Recovery

    Jeff Moden - Thursday, November 8, 2018 8:03 AM

    edwardwill - Thursday, November 8, 2018 3:55 AM

    November 8, 2018 at 5:34 pm

    #2012921

  • RE: Non sequential sequential numbers

    Sean Lange - Thursday, November 1, 2018 7:12 AM

    I have never been convinced that using sequential guids is a viable architecture. Sure...

    November 1, 2018 at 10:42 am

    #2012075

  • RE: Implicit Transactions

    It was easy to rule out option three - it read, "An error as TRUNCATE TABLE cannot be used with implicit conversions set on."  Since it was implicit transactions that...

    September 20, 2018 at 12:01 pm

    #2006466

  • RE: The Helpful Triggers

    The DDL is separate from the table

    This tells me you're not modifying the SSMS defaults for script generation.  There are a plethora of options I update in the...

    September 11, 2018 at 3:49 pm

    #2005347

  • RE: How am I doing?

    Luis Cazares - Wednesday, August 15, 2018 11:26 AM

    Technically, there wouldn't be any negatives for Sales Weeks. That would mean that...

    August 15, 2018 at 11:47 am

    #2001950

  • RE: How am I doing?

    Steve Jones - SSC Editor - Wednesday, August 15, 2018 9:08 AM

    t.ovod-everett - Tuesday, August 14, 2018...

    August 15, 2018 at 10:14 am

    #2001927

  • RE: How am I doing?

    Won't you get 100 rows?  If you only want 9, you'll need a "WHERE m.n <= 9" or some such.

    August 14, 2018 at 3:49 pm

    #2001764

  • RE: The UPDATE() function

    lmalatesta - Friday, August 10, 2018 7:52 AM

    timwell - Friday, August 10, 2018 7:39 AM

    August 13, 2018 at 10:36 am

    #2001525

  • RE: OUTPUT values

    Lynn Pettis - Tuesday, August 7, 2018 1:37 PM

    This is really about the principle behind using the OUTPUT clause, not what...

    August 7, 2018 at 2:02 pm

    #2000707

  • RE: OUTPUT values

    One observation is that outputing just the OrderKey column won't enable you to easily determine which of the two inserted records got which of the two OrderKey values.  One might...

    August 7, 2018 at 1:29 pm

    #2000703

  • RE: Assignments

    lmalatesta - Tuesday, July 3, 2018 8:22 AM

    Note: this behavior also only works for variables. For column assignments in update statements,...

    July 3, 2018 at 4:18 pm

    #1996236

Viewing 15 posts - 16 through 30 (of 54 total)