Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    202

    Unanswered: copy from one table to the other using stored procedure

    Hi there,

    How to the scripts for copying data in table A to table B using stored procedure?

    Thanx

  2. #2
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70
    INSERT INTO Table_A
    SELECT * FROM Table_B

  3. #3
    Join Date
    Mar 2004
    Posts
    202
    Hi there,

    I got this one prob.................i have to copy from data which consist in the VIEWS section in SQL Server Enterprise Manager.
    This views section already contain the script which limit the user to few databases and i need to copy watever display in the view section to a new table in other database.
    Thanx

  4. #4
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    copy from one table to the other using stored procedure

    Hi there...

    Maybe this will help:

    Select * into Other_db..newTable from Source_db..View

    Other_db = the database where the new table should be created
    newTable = the name of the new table
    Source_db = is the database where you query the view
    View = the name of the View

    I hope this helps.

    Greetz,
    Marc,

  5. #5
    Join Date
    Mar 2004
    Posts
    202

    Re: copy from one table to the other using stored procedure

    thanx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •