Subject | is where 1=0 needed? |
---|---|
Author | bill_lam |
Post date | 2006-06-29T00:55:34Z |
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
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