97
Chapter 5: SQL Server Management and Development Tools
5
■ (^) Grid pane: Lists the columns displayed, fi ltered, or sorted.
■ SQL pane: You can enter or edit the raw SQL SELECT statement in this pane.
■ (^) Results pane: When the query is executed with the Run button (!), the results
are captured in the results pane. If the results are left untouched for too long,
Management Studio requests permission to close the connection.
A cool feature in Management Studio is the capability to create and graphically join derived tables within Query
Designer’s Diagram pane.
FIGURE 5-8
Object Explorer’s Query Designer.
The Query Designer can perform Data Manipulation Language (DML) queries — (SELECT,
INSERT, UPDATE, DELETE) besides SELECT. The Change Type drop-down list in the Query
Designer toolbar offers to change the query from a default select query to an Insert Results,
Insert Values, Update, Delete, or Make Table query.
c05 July 23, 2012 11:44 AM V1
c05.indd 97c05.indd 97 7/30/2012 4:14:48 PM7/30/2012 4:14:48 PM
http://www.it-ebooks.info