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
In SQL Server Object Explorer, double-click PerishableFruits under Views to open it in Transact-SQL editor.
Highlight the SELECT p.Id, p.Name FROM dbo.Product p segment in the code, right-click and select Execute Query.
Notice that all the rows with the specified fields in the Products table are returned in the Results pane.