Database Tutorials

Database Tutorials

How to create a column alias in the Criteria Pane in SQL server

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 …

Learn more

How to remove a column from the query in the Criteria or SQL Pane in SQL Server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to remove a column from the query, they should do the next:

– In the Criteria Pane, select the grid row containing the column they want to remove and then press DELETE.

How to add an individual column in the Diagram or Criteria Pane in SQL server

When developers want to use a column in a query they must add it to the query. They can add a column a column to display it in query output, to use it for sorting, to search the contents of the column, or to summarize its contents. Developers can decide which of the columns they use …

Learn more

How to add an existing query to a new query in the SQL Pane in SQL server

When developers create a query, they are retrieving data from a table or other objects structured like tables — views and certain user-defined functions. To work with any of these objects in their query, they add them to the Diagram Pane.When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server …

Learn more