Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Viewing Plans

    The correct answer is invalid syntax. It should be

    GRANT SHOWPLAN to JoeDev

    Instead of

    GRANT VIEW SHOWPLAN to JoeDev

    February 1, 2018 at 1:28 am

    #1978136

  • RE: Temporary tables and procedures

    Budd - Tuesday, December 19, 2017 7:18 AM

    Good question.
    My Question is why?  Doesn't the Procedure run within a separate session, and aren't...

    December 20, 2017 at 2:40 am

    #1972854

  • RE: Fun Data Arithmetic

    Jeff Moden - Tuesday, October 31, 2017 8:54 AM

    DATETIME2 fixed nothing and I avoid it like the plague because...

    October 31, 2017 at 9:20 am

    #1965997

  • RE: Fun Data Arithmetic

    ildjarn.is.dead - Tuesday, October 31, 2017 1:12 AM

    I think it stores the dates as floats, not ints.

    According to the documentation datetime...

    October 31, 2017 at 2:10 am

    #1965907

  • RE: Vertical Blocks of Code

    amish-215805 - Wednesday, February 15, 2017 12:10 AM

    its working using alt+shift not alt.

    Shift is not required, and forms part of the "Selecting...

    February 15, 2017 at 1:23 am

    #1928557

  • RE: T-SQL: EOMONTH

    Alvin Ramard (9/19/2016)

    BrainDonor (9/19/2016)

    I couldn't see any of the answers that matched what I believed I should be getting - then I played around a little.

    Where dates are concerned it...

    September 20, 2016 at 5:54 am

    #1901828

  • RE: VALUES limit

    paul.knibbs (9/16/2016)

    I do wonder why the limit is set at that. Is it just an arbitrary number Microsoft plucked from the air, or is there an actual reason for it?

    I...

    September 16, 2016 at 2:17 am

    #1901292

  • RE: CAST tinyint to nvarchar

    According to CAST and CONVERT, an E should be returned, but that is not the case.

    Below the table where it states that "E" will be returned there is a footnote...

    February 26, 2016 at 2:10 am

    #1861331

Viewing 8 posts - 1 through 8 (of 8 total)