Posted by
Andrew Gould on 16 January 2013 | no comments
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!
Posted by
Andy Brown on 08 November 2012 | no comments
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.
Posted by
David Wakefield on 02 July 2012 | no comments
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
Posted by
Andrew Gould on 13 February 2012 | 1 comment
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.
Posted by
Andrew Gould on 13 February 2012 | 1 comment
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!