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 in the query are included in the results pane when the query is run. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add an individual column, they should do the next:

– In the Diagram Pane, select the check box next to the column that they want to include.


– In the Criteria Pane, move to the first blank grid row, click the field in the Column column, and select a column name from the drop-down list.