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,313 reads

Blogs

Event Log File Paths

By

How does one consistently find the correct path to the Extended Event Log file...

Clearing an Email from the Microsoft Directory

By

Years ago I was working on a demo with Microsoft and someone added me...

Learning Containers

By

I find that I’m using containers more and more to get things done with...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

DBA Walkthrough – Adding space on IBM AIX Power Machines

By SOLVARIA

Comments posted to this topic are about the item DBA Walkthrough – Adding space...

The Datatimeoffset Value

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Datatimeoffset Value

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers