Skip to content

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

Latest commit

 

History

History
28 lines (21 loc) · 1.16 KB

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

File metadata and controls

28 lines (21 loc) · 1.16 KB
title Execute a Partial Query
ms.prod sql
ms.technology ssdt
ms.topic conceptual
ms.assetid af04ab37-6cbb-4185-9382-e5922fa5b1df
author markingmyname
ms.author maghan
manager jroth
ms.reviewer “”
ms.custom seo-lt-2019
ms.date 02/09/2017

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.