SQL Server Queries Part 7 - Using Functions In Queries

By Andrew Gould

http://www.wiseowl.co.uk - Learn the basics of using functions in Microsoft SQL Server queries. This video teaches you how to use functions to create calculated columns in a query, including where to find a list of available functions, how to work out which parameters you need to fill in using the help system, and how to combine functions in more elaborate calculations.

Some of the functions used in this tutorial are explained in written form here:
http://www.wiseowl.co.uk/blog/s330/string.htm

For a written explanation of how dates work, see here:
http://www.wiseowl.co.uk/blog/s216/date_and_time_calculations_in_sql_server.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!