BY TOPIC▼
SQL SERVER BLOGS▼
SQL BLOGS▼
- General (13)
- Tables and columns (11)
- Selecting data (8)
- WHERE criteria (5)
- Calculations (8)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (6)
- Programming tables (4)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (4)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on WHERE criteria in SQL
Showing blogs 1-5 (out of 5)
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.
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
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.
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!