Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

Calculations in SQL blogs

Calculating Age in SQL with a User-Defined Function

Posted by Andrew Gould on 16 February 2012 | no comments
A common requirement in SQL queries is calculating a person's age. The expression you need to do this accurately is relatively long, so why not replace it with a user-defined function? This blog shows you how!

This blog is part of our complete SQL Tutorial.

Tags:   SQL / Calculations   |   SQL / Functions

SQL Server Tutorial

Posted by Andrew Gould on 13 February 2012 | no comments
This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.
Tags:   SQL / Selecting data   |   SQL / WHERE criteria   |   SQL / Calculations   |   SQL / Joins   |   SQL / Grouping   |   SQL / Stored procedures   |   SQL / Transactions   |   SQL / CTEs, subqueries

Dates and Times in SQL Server

Posted by Andrew Gould on 13 February 2012 | no comments
Dates and times can be the most frustrating data types to work with in SQL Server. Learn everything you need to know about the way dates work with this handy blog series and enjoy happier times!

This blog is part of a larger tutorial on SQL Server, which you can read here.

Tags:   SQL / WHERE criteria   |   SQL / Calculations