Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Copying Tables
0 views
Skip to first unread message
justin b
Nov 1, 2000, 11:25:01 AM11/1/00
to
Hi
I need to create one table as a copy of an existing table.
I need to create one table as a copy of an existing table.
I thought the syntax was as follows:
CREATE table2 AS SELECT * FROM table1
but this does not work
Can anyone help me?
please email to jus...@absolve.co.uk
many thanks
--
Justin
Gennady
Nov 1, 2000, 12:23:23 PM11/1/00
to
It works for Oracle, not for MS SQL Server.
For MS SQL Server use this:
SELECT * INTO Table2 FROM Table1
but make sure that appropriate database property settings are correct
(bulk copy/select into - checked).
For MS SQL Server use this:
SELECT * INTO Table2 FROM Table1
but make sure that appropriate database property settings are correct
(bulk copy/select into - checked).
Good luck.
justin b wrote in message <3a004...@d2o313.teliauk.com>...
0 new messages