how-to-execute-a-partial-query.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
Execute a Partial Query	Get help debugging a section of a complex query. Use the Transact-SQL Editor to highlight a specific script segment and execute it as a single query.	markingmyname	maghan	02/09/2017	sql	ssdt	conceptual

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.

Warning

The following procedure uses entities created in previous procedures in the Connected Database Development and Project-Oriented Offline Database Development sections.

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.