{ SQL: T-SQL }
Backup a Table (select into)
use the following T-SQL to backup a table
Execute a DTS Package from T-SQL
The following is an example of how you can execute a DTS package using T-SQL.
T-SQL: Create Table from Another Table's Contents
The following T-SQL will insert all rows from OldTable into a newly-created table, NewTable. The NewTable table will automatically be created when the statement is run.