Tabbed
functionalKeep 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
SELECTyou 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 namecomment 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.


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.