tSQL: Where 1=0

[NewsBot]

I just came across this little gem while perusing the code of someone who recently left the company:

 

SELECT TOP 1 * from tblSomething WHERE 1=0

 

Can anyone tell me what would be the motivation here? Am I missing something? Seems to me they're looking for column names... which I would expect to look more like:

 

SELECT TOP*0 * from tblSomething

 

Wouldn't that do exactly the same thing, but with less load on the SQL server?

 

 

Edit: More did you say?

 

with mySqlCommand

*.CommandText = "... do stuff..."

*.Connection = mySqlConnection

*.ExecuteNonQuery()

end with

 

with mySqlCommand* 'The same one!

*.CommandText = "... do something else..."

*.Connection = mySqlConnection

*.ExecuteNonQuery()

end with

 

It can't be me... It has to be the rest of the world... Bah, it's time to go rant on the blog...

 

 

More...

 

View All Our Microsoft Related Feeds