What I would like to do is calculate the values in the SQL Query instead so that I can sort by those columns. How do I assign values based on other fields to a temporary field name?<P>Hope this ...

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?<BR><BR>Thanks,<BR><BR>Pete ...

To optimize slow SQL queries, start by using indexing on columns used in WHERE, JOIN, or ORDER BY clauses. Analyze execution with an EXPLAIN PLAN to identify inefficiencies.

[!INCLUDE SQL Server] To use a column in a query, you must add it to the query. You might add a column to display it in query output, to use it for sorting, to search the contents of the column, or to ...

Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions. To add, drop, or modify a ...