Re: Help optimize Dataset copy code



You could do that with single SQL:
SELECT *
into <DEST_TABLE>
from <SOURCE_TABLE> in "" [ODBC;DRIVER={SQL
Server};SERVER=<SERVER_NAME>;DATABASE=<DB_NAME>]

Note: it is assumed that <DEST_TABLE> doesn't exist.


.