98
Part I: Laying the Foundations
However, the Query Designer is no substitute for the Query Editor. Unlike Query Editor, it
cannot perform batches or non-DML commands. Nor can it execute SQL statements using F5.
Table and column names can’t be dragged from the Object Explorer to the SQL pane.You can use the Query Designer to edit data directly in the results pane — a quick-and-
dirty way to correct or mock up data.Navigating the Query Designer should feel familiar to experienced Windows users. Although
Books Online lists several pages of keyboard shortcuts, most are standard Windows navigation
commands. The one worth mentioning here is Ctrl+0, which enters a NULL into the result pane.Object Explorer Reports
No section on Object Explorer would be complete without mentioning the dozens of great
reports hidden within, one of which is shown in Figure 5-9. You can fi nd these reports
in the context menus of server, database, and security ➪ login nodes. While all reports
aren’t listed here, they’re an excellent resource and one of the most underused features of
Management Studio.FIGURE 5-9
The server or database standard reports are a great way to quickly investigate your SQL
Server.c05 July 23, 2012 11:44 AM V1
c05.indd 98c05.indd 98 7/30/2012 4:14:49 PM7/30/2012 4:14:49 PM
http://www.it-ebooks.info