'WHERE 1 =1' in SQL Stored Procedure

Question

Possible Duplicate:
Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?

I've been tasked with reviewing some SQL stored procedures and have seen many that look like the following:

SELECT 
  X, Y, Z 
FROM 
  Table
WHERE 
  1 = 1
ORDER BY
  X

Why would someone use '1 = 1' for the where clause?

Thanks!

Possible duplicate: http://stackoverflow.com/questions/242822/why-would-someone-use-where-11-and-conditions-in-a-sql-clause — steinar, Nov 01 '10 at 02:04
@steinar - Thanks. I did try some searches, but had no luck. This is a dupe. — derivation, Nov 01 '10 at 02:07

score 8 · Accepted Answer · answered Nov 01 '10 at 02:01

8

It's common in dynamic SQL, in order to append additional criteria to a WHERE clause. Otherwise, it's useless and it is ignored by the optimizer.

answered Nov 01 '10 at 02:01

OMG Ponies

score 2 · Answer 2 · answered Nov 01 '10 at 02:00

2

possibly to dynamically add conditions to the where clause.

answered Nov 01 '10 at 02:00

zerodin

2 Answers2