Forum Replies Created

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

  • RE: Building Better Stored Procedures

    Jeff Moden - Thursday, March 14, 2019 9:08 PM

    astruthers 75845 - Thursday, March 14, 2019 2:24 PM

  • RE: Building Better Stored Procedures

    sqlservercentral-631096 - Thursday, March 14, 2019 2:50 AM

    Hey Steve,
    Great article, and thanks for sharing.
    You discussed whether to use create procedure or create...

  • RE: Who Works on What?

    Luckily I already had my first cup of coffee on board before I tackled this.

  • RE: Data Type Precedence

    I figured precedence should cast @txt to some form of datetime. But I didn't like any of the answers, because I didn't think you could add two datetimes together. The...

  • RE: Logical Query Processing Filters

    Apparently it wasn't just me. I swear I clicked HAVING...

  • RE: Dynamic SQL and TempTables

    I get what he's trying to do, but procedures return an INT. This procedure never sets a return value, so it returns a 0.

  • RE: Only Use My Application

    We use a logon trigger

  • RE: SSMS Tricks - Results

    Jeff Atherton - Wednesday, March 15, 2017 6:55 AM

    Works in SSMS 2014 as well.

    ... and 2012, and 2008 R2.

  • RE: SSMS Tricks - Results

    Wow - never new this one, and I'm all about keyboard shortcuts. Moving the splitter was never satisfactory, so for years I've been closing the file and reopening, just so...

  • RE: Vertical Blocks of Code

    Koen Verbeeck - Thursday, March 2, 2017 7:48 AM

    What's also cool with this feature is that you can type on all lines...

  • RE: Vertical Blocks of Code

    Ed Wagner - Friday, February 17, 2017 6:47 AM

    This is one of the handiest editing features.  I'm surprised by how many people...

  • RE: Vertical Blocks of Code

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

    its working using alt+shift not alt.

    Alt+Shift selects a block when using the keyboard. Alt by...

  • RE: Age as of January 1st

    dale_berta - Tuesday, January 31, 2017 5:43 AM

    ScottPletcher - Monday, January 30, 2017 2:14 PM

  • RE: Age as of January 1st

    ScottPletcher - Monday, January 30, 2017 2:14 PM

    All you need is year, since any birthday during the @Service year won't count anyway:

    DECLARE...

  • RE: Computer Math

    Interesting. Is this in every release of T-SQL, or could this vary?

    I only ever use the += with single values on the right-hand side, so I haven't encountered this. Seems...

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