Posted by Mukesh_Singh_Nick on 10/17/07 13:44

I've come accross queries like this one previously but never got the
time to carefully study them form some book.

SELECT 1 WHERE 1 = 1


1) What do queries like these mean? From common sense, I can deduce
that it is some kind of a test for a boolean value, but the result is
already deterministic in the above case (true).

What use is such a query for?

2) What dialect of SQL (ANSI/T-SQL) does MS-SQL Server use?

• Next in forum: A suitable SQL Server book for my goals
• Prev in forum: Can you help me test my MS SQL test on my new testing website
• Thread view: What are these queries used for?

[Reply to this message]