Post reply

adding a Select statement to an existing table

  • June 15, 2020 at 9:17 am

    #3763042

    I have this table abc. when I script it out it contains Create table and Alter procedure commands.

    Now I want to add a Select statement to this table, so when I script out the next time it should consist of Create table, Alter procedure and the new Select statement

    Is there a way to do this.

    Regards

     

    Atulyan Padmanabhan

     

  • June 15, 2020 at 9:55 am

    #3763057

    What tool are you using as SSMS doesn't do that by default.

    If it is within SSMS what plugins do you have?

  • June 15, 2020 at 9:56 am

    #3763058

    no tools

  • June 15, 2020 at 10:33 am

    #3763065

    Please post screenshots and a walkthrough as by default when you script a table via the gui it only scripts the table.  not the procedures also.

  • June 15, 2020 at 1:53 pm

    #3763131

    Sorry... post removed.  Apparently, I posted to the wrong thread.

    • This reply was modified 4 years, 5 months ago by  Jeff Moden.

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

  • June 15, 2020 at 2:17 pm

    #3763149

    It's not quite clear what you want here. What would the SELECT statement include?

    The scripting engine in SQL Server produces the DDL code for the object, but does not include the data. You can use a bacpac export, which is the table + data, with the Export Data Tier Application option under the Tasks (right click the db name)

  • June 15, 2020 at 2:19 pm

    #3763152

    Jeff, to which article are you referring?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 15, 2020 at 3:25 pm

    #3763184

    Phil Parkin wrote:

    Jeff, to which article are you referring?

    Sorry... post removed.  Apparently I replied on the wrong thread.

     

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

  • June 15, 2020 at 10:37 pm

    #3763312

    atulyan.aries wrote:

    no tools

    Ok then... let's reword the question... how are you producing the scripts that you cite in your original post?

    --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 9 posts - 1 through 8 (of 8 total)

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