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