114
Part II: Building Databases and Working with Data
FIGURE 6-1
Use the Query Designer to graphically create queries.Logical Flow of the Query Statement
The best way to think through a SQL DML statement is to walk through the query’s logical
fl ow (see Figure 6-2). Because SQL is a declarative language, the logical fl ow may or may not
be the actual physical fl ow that SQL Server’s query processor uses to execute the query. Nor
is the logical fl ow the same as the query syntax. Regardless, think through a query in the
following order.c06.indd 114c06.indd 114 7/30/2012 4:15:57 PM7/30/2012 4:15:57 PM
http://www.it-ebooks.info