Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 Caution:
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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.