The SQL editor allows users to execute SQL scripts. For Transact-SQL scripts, you can use the word “GO” to separate the SQL statement. For other type of SQL scripts, such as PL/SQL, PL/pgSQL, DB2, and MySQL scripts, use “;” to separate the SQL statement.
You can highlight a list of statements and click the “Execute” toolbar button to run them as a script. Without highlighting anything, the “Execute” button will run the whole content in the SQL editor as a script.
If there are multiple select statements in a script, multiple query result windows will be opened to display the result.
The “Messages” view shows the result message for each SQL statement.