Monday, February 20, 2012

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;I guess you can do it as
select * into table1 from table2 which is a bulk copy.

No comments:

Post a Comment