Copy a Table – MSDE

Written by James McDonald

November 12, 2007

Using osql log into the database

osql -S SERVERNAME\INSTANCENAME -U dbusername
Password: *********
1>use dbname
2>go
1>SELECT * INTO new_target_table FROM old_source_table
2>go

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

You May Also Like…