Tabbed

functional

Keep the workspace calm by looking at one result set at a time.

Tabbed is the default for a reason: each result set gets a tab and only the active one is visible. It is the calmest choice when you are focused on one answer at a time.

When it is the right choice

  • A batch where one set matters. A script that ends in the SELECT you care about puts that set one click away and the rest out of the way.
  • Wide results. One grid gets the full width and height of the pane, which is the difference between reading a forty-column row and scrolling it.
  • Big results. A set's grid is built the first time you open its tab, and only the active grid is drawn, so a batch of several large sets does not pay to lay out grids you never look at.

Working with the tabs

The result tabs sit at the left of the results tab bar, followed by Messages and the other output panes. Click a tab to bring its grid forward; ⌘1 (Ctrl1 on Windows and Linux) returns to the results from Messages, and ⌘2 goes the other way.

  • Names. Tabs read Results 1, Results 2, and so on. Click the pencil beside a title to rename it; Enter saves and Esc cancels. The name is stored as a -- sqlly name comment in your SQL, so it survives the next run (see Layouts).
  • Empty sets say so. A finished query that matched nothing shows No rows returned under its column headers, instead of a blank grid that looks like a failure.
  • Each tab is a full grid. Sorting, filtering, and formatting apply to that tab only, and each has its own Grid, Pivot, and Chart tabs - so you can chart set 2 while set 1 stays a plain grid.

An example

A customer lookup that returns the customer and then their recent orders:

-- sqlly name 1: Customer
-- sqlly name 2: Recent orders
SELECT customer_id, name, email, country
FROM dbo.Customers
WHERE customer_id = 1042;

SELECT order_id, order_date, status, total
FROM dbo.Orders
WHERE customer_id = 1042
ORDER BY order_date DESC;

Tabbed shows two tabs, Customer and Recent orders. The one-row customer set does not steal space from the order list, and the orders grid gets the whole pane. If you find yourself flicking back and forth between the two, that is the cue to try Stacked.

Switching to it

Click Result layout on the results tab bar, use the layout toggle in the query toolbar, or right-click any cell or column header and choose Tools › Layout › Tabbed Layout. Your choice is remembered per editor tab when session resume is on.

SQLly
SQLly tabbed result layoutSQLly tabbed result layout
Several result sets shown as a tab strip, one grid visible at a time.

A very large set may be paged from disk rather than held in memory; that works the same in every layout. See Unbounded, spill-to-disk results.