Saving SQL Statements to a File

In Interactive SQL, the output for each command remains in the Results pane until the next command is executed. To keep a record of your data, you can save the output of each statement to a separate file.

If statement1 and statement2 are two select statements, then you can save them them to file1 and file2, respectively:

Statement1; OUTPUT TO file1
go
statement2; OUTPUT TO file2
go

For example, this command saves the result of a query:

select * from titles
go
output to "C:\My Documents\Employees.txt"