Developers create aliases for column names to make it easier to work with column names, calculations, and summary values. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to create a column alias, they should follow the next steps:
1. In the Criteria Pane, locate the row containing the data column for which they want to create an alias, and if necessary, mark it for output. If the data column is not already in the grid, add it.
2. In the Alias column for that row, enter the alias. The alias must follow all naming conventions for SQL. If the alias name they enter contains spaces, the Query and View Designer automatically puts delimiters around it.