SQL Tip for Collapsing a Long Query

SQL Tip: Saving Code Space When Using SQL Server Management Studio Queries

A long query in SSMS:

Click the minus sign next to the long query to collapse the query:

Highlight the collapsed query:

Click “Execute” or hit F5 to run the query and have room to view the full result set:

For more Microsoft Technical Training information visit www.directionstraining.com or call 1-855-575-8900.