SQL Statements in Interactive SQL

You can enter all SQL statements as commands in the top pane of the Interactive SQL window. When you are finished typing, execute the statement to run it.

If you are running a long-running query, Interactive SQL displays a splash screen that describes some diagnostic tips.

• Canceling an Interactive SQL Command
  Use the Interrupt button on the Interactive SQL toolbar to cancel a command.
• Combining Multiple Statements
  Interactive SQL allows you to enter multiple statements at the same time. End each statement with the Transact-SQL command, go.
• Looking Up Tables, Columns, and Procedures
  Use Tools > Lookup Table Name and Tools > Lookup Procedure Name to look up the names of tables, columns, or procedures stored in the current database and insert them at your cursor position.
• Recall Commands
  When you execute a command, Interactive SQL automatically saves it in a history list that lasts for the duration of your current session. Interactive SQL maintains a record of as many as 50 of the most recent commands.
• Logging Commands
  With the Interactive SQL logging feature, you can record commands as you execute them. Interactive SQL continues to record until you stop the logging process, or until you end the current session. The recorded commands are stored in a log file.