The primary tool that facilitates the development of SQL statements is the Query/View Designer, which is a graphical tool that enables you to build queries with a point-and-click interface. After a query is constructed, this tool also enables you to view and interact with any results returned as a result of executing the query.
Now you’re ready to put this tool through its paces.
Creating a new select query against a table is as simple as selecting the database in Server Explorer and then, under the Data menu, selecting New Query. An initial prompt gathers a list of the tables, views, functions, and/or synonyms to use as the target of the query (see Figure 21.13).
After you have selected ...