sql tip (was: RE: [thelist] Hello)
Scott Dexter
sgd at ti3.com
Tue Dec 19 16:08:46 CST 2000
> in sql/server you can copy a table with
> select *
> into newTable
> from oldTable
> you don't have to pre-define newTable, but i think you have
> to enable the
> bulkcopy option (sgd, please confirm, you know i aint a dba)
yes, you have to enable the bulk copy option (in MS SQL Server, the option
is labelled "Select Into/Bulk Copy" to help you remember) because the Select
Into statement is not logged....
sgd
More information about the thelist
mailing list