Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Building Better Stored Procedures RE: Building Better Stored Procedures

  • March 14, 2019 at 9:08 pm

    #2024521

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

    In your example, those notes that come BEFORE the ALTER\CREATE statement are lost.

    That's not actually true if you're using SSMS.  The comments before the Create statement WILL actually be included in the stored procedure.  Try it yourself and see.

    As to  whether or not that's the correct way to do things or not, my take is that the first thing in a stored procedure should be the ALTER or CREATE statement.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)