Return
-
Title
How to run multiple SQL query statements in one Editor Window, one at a time without having to hi -
Description
How to run many or several individual SQL query statements grouped together in one Editor Window, one at a time without having to highlight each SQL query first?
For example, I want to run the whole script below, one query at a time without having to highlight a particular query first.
select*from aaa
go
select*
-
Resolution
Use the “Execute the current SQL statement (F9)” feature. It will only execute the SQL statement where the cursor is at and you do not have to highlight an individual query statement first. You have to use “go” as using “;” (semi-colon) will not work or will still execute all SQL statements in the whole Editor Window.
If you want to add the “Execute the current SQL statement (F9)” icon in your Toolbar, right-click the Toolbar area | click Customize | then Commands Tab | then Editor | then drag-and-drop the “Execute Current Statement” icon into your Toolbar area. NOTE: It will show up as two of the same icons in the Toolbar, but the other icon will disappear when you close the Customize window.