Blogs from Wise Owl on WHERE criteria in SQL

Using Criteria in SQL Queries

Posted by Andrew Gould on 16 January 2013

When you write queries in SQL it's immensely useful to be able to show records matching criteria that you've set. You can do this using the WHERE clause and this blog teaches you how to use it!

Setting SQL criteria using the WHERE clause

Posted by Andy Brown on 08 November 2012

If you don't want to see a full set of records from a table in SQL, you can use a WHERE statement to filter out unwanted rows, as shown in this blog.

Dynamic SQL - No, No, No!

Posted by David Wakefield on 02 July 2012

Dynamic SQL should only be used as a last resort. This article gives you a tip for avoiding the use of dynamic SQL in WHERE clauses

Free SQL training course | SQL tutorial

Posted by Andrew Gould on 13 February 2012

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.

Dates and Times in SQL Server

Posted by Andrew Gould on 13 February 2012

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!