Skip to content

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

Latest commit

 

History

History
31 lines (25 loc) · 1.25 KB

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

File metadata and controls

31 lines (25 loc) · 1.25 KB
Raw
title How to: Execute a Partial Query | Microsoft Docs
ms.custom
SSDT
ms.date 02/09/2017
ms.prod sql
ms.technology ssdt
ms.reviewer
ms.suite
ms.tgt_pltfrm
ms.topic conceptual
ms.assetid af04ab37-6cbb-4185-9382-e5922fa5b1df
caps.latest.revision 11
author stevestein
ms.author sstein
manager craigg

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.