How to: Execute a Partial Query

The Transact-SQL Editor allows you to highlight a specific segment of the script and execute it as a single query. This makes it easy for you to debug sections of complex queries.

To partially execute a query

1. In SQL Server Object Explorer, double-click PerishableFruits under Views to open it in Transact-SQL editor.

2. Highlight the SELECT p.Id, p.Name FROM dbo.Product p segment in the code, right-click and select Execute Query.

3. Notice that all the rows with the specified fields in the Products table are returned in the Results pane.