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:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

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.