Microsoft Business Intelligence Tools for Excel Analysts by Michael Alexander Jared Decker & Bernard Wehbe

Author:Michael Alexander, Jared Decker & Bernard Wehbe
Language: eng
Format: epub
ISBN: 9781118821565
Published: 2014-04-11T10:54:47+00:00

Click the columns that you want to add to your view.

Figure 8-17: View design window.

The columns are automatically added to the SQL statement (see Figure 8-18).

After you have finished selecting all the columns and tables you want to add, click the Save icon on the menu bar.

Enter the view name. Make sure to follow a standard naming convention to make it easier to maintain the system. Here are some common conventions for naming objects in SQL server:

Limit the name to approximately 50 characters (the shorter the name, the better).

Avoid using spaces in the name. Instead, use camel case (using uppercase for the first letter of each word, as in SalesAmount).

Avoid using numbers and underscores in the name.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.