SQL Server Queries Part 4 - Calculated Columns In Queries

By Andrew Gould

http://www.wiseowl.co.uk - Learn how to use calculations in queries in Microsoft SQL Server. This video teaches you how to create basic calculated columns using simple operators such as add, subtract, multiply and divide. You'll also see how to use calculated columns to sort the results of a query, and how to add criteria to calculated columns.

You can view a written version of this tutorial at:
http://www.wiseowl.co.uk/blog/s330/calculations.htm

You can download the script to create the Movies database used in this video at the following link:
http://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip

You can see the range of resources and courses we offer in SQL Server here:
http://www.wiseowl.co.uk/sql/

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!