How to do it...

1. Open SQLA.
2. To change the behavior of the resultset, click on Tools | Options ..., highlighted in the following screenshot:

1. From the pop-up window, click on the Query tab, as highlighted in the following screenshot:

1. Next, uncheck the following boxes as shown in step 1; option 1 will make sure that your old answer set is not closed when you are submitting your query. Tick the 7; option will help you execute highlighted queries when you have multiple queries in your window:

1. There are many other options that, if you want, you can check and uncheck.