Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Question Unanswered: is there an equivalent table copy command in ms sql a la oracle?

    is there a command in ms sql server 2000 equivalent to this oracle table copy command?

    create table myTable_bak as select * from myTable;
    Last edited by testmonger; 04-15-04 at 19:46.

  2. #2
    Join Date
    Jan 2004
    Posts
    35
    I guess you can do it as
    select * into table1 from table2 which is a bulk copy.

Posting Permissions

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