results. However, this view offers more information about (Domain and web hosting)
results. However, this view offers more information about who made each purchase including each user s e-mail address, the date he or she created the account, the date of the user s last login, and more. Figure 11-31 shows the results but actually the results table is wide enough to see all the columns. Suffice it to say that for every checked field name in Figure 11-30, there s a field containing data in the query results. For purposes of future examples, I saved the query shown in Figure 11-30 as DetailedUsersItemsView, so in my own Database Explorer, that name has been added to the list of Views in the current database (as in Figure 11-32). To execute a view to see only the data it retrieves without seeing its design you can right-click the view name and choose Show Results. The way the data looks in the view results is of zero importance. Formatting takes place when you display data from a view in a Web page. Figure 11-32: Two new Views added to the database. Figure 11-31: Results of executing the detailed query. Chapter 11: SQL Server Crash Course 253
If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.