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