Results 1 to 2 of 2

Thread: Create table selecting from another

  1. 03-05-2001, 11:49 AM #1
    Fabio Aneas Guest

    Create table selecting from another

    Hi!
    I need to create a table and populate it with other table's contents. I know this can be done DTS, I wonder if there are means to make it throught a single TSQL command.
    Thanks,
    Fabio
    Reply With Quote Reply With Quote
  2. 03-05-2001, 12:20 PM #2
    Lena Guest

    Create table selecting from another (reply)

    Fabio

    select * into new_table
    from existing_table

    Regards,
    Lena


    ------------
    Fabio Aneas at 3/5/01 11:49:04 AM

    Hi!
    I need to create a table and populate it with other table's contents. I know this can be done DTS, I wonder if there are means to make it throught a single TSQL command.
    Thanks,
    Fabio
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules