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