Subject is where 1=0 needed?
Author bill_lam
Hi all,
I originally code it in odbc, but here I rephrase using sql jargon.

Often I declare a cursor for inserting rows using
select a,b,c from t
or
select a,b,c from t where 1=0

Actually a cursor (statement handle) is prepared and no rows will be fetched.
Does the clause "where 1=0" have any significance? I found speed for both of
them is the same even for a large table. I would like to have some confirmation
to drop that clause.

TIA

regards,
bill