Sotiris Filippidis

Conditional Statements in WHERE Clauses

T-SQL is a powerful language, enabling you to handle many different types of set based operations. But having flexible WHERE clauses isn't something that many DBAs deal with on a daily basis. New Author Sotiris Filippidis brings us an article on how you can structure a WHERE clause to handle all types of strange business logic without using dynamic SQL. Read on to learn more about his technique.

3.62 (53)

2007-09-28 (first published: )

34,315 reads

Blogs

Daily Coping 13 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – August 2020 – More DML Triggers

By

Well, I’m running a bit late. Both for this month and the fact I...

Your First Databricks Notebook

By

On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Guidance on Application changes to support the 2014 Cardinality Estimator update

By Steve

Hello all. We recently had an opportunity to discover a hidden treasure in SQL...

XE predicate order

By dbgaragedays

Hello, I am reading Stellato's Extended Events Stairway series and in the final (4th)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers