Post reply

SP for creating insert/update/delete/get/list SPs

  • September 20, 2006 at 7:57 am

    #153192

    Hey all,

    Can any provide me an SP which in turn will create SPs for INSERT/DELETE/UPDATE/GET SPs for a table?

     

    --Ramesh

  • September 20, 2006 at 8:14 pm

    #661616

    It's already been done... in QA, open the object browser (press the {f8} key), drill down to the table of choice, right click on the table and select [Script Object to new window as]...

    Then select SELECT, INSERT, UPDATE, or DELETE.

    Least expensive way to format it is using search and replace in Word...

    If you want it to be really pretty, you'll need to write some dynamic SQL that interogates the INFORMATION_SCHEMA.COLUMNS view.

    --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)

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

You must be logged in to reply to this topic. Login to reply