Blogs from Wise Owl on WHERE criteria in SQL

Showing blogs 1-5 (out of 5)

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!

Tags:   SQL | WHERE criteria    |    T-SQL | SQL Tutorial

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.

Tags:   SQL | WHERE criteria    |    T-SQL | SQL Tutorial

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

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Dynamic SQL    |    T-SQL | Other

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.

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Calculations    |    SQL | Joins    |    SQL | Grouping    |    SQL | Stored procedures    |    SQL | Transactions    |    SQL | CTEs, subqueries    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | WHERE criteria    |    SQL | Calculations    |    T-SQL | SQL Tutorial
This page has 0 threads Add post