Changing NOT <>

Question

Changing NOT <>

aruram

SSCrazy

Points: 2379
More actions
April 25, 2008 at 10:41 am

#69929

Is it possible to rewrite the following query to NOT use the <> and achieve same result and better perfromance
update tblTest_Results set status=1
where id<>@ID
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Eddie Wuerch SSChampion Points: 12535 More actions · Answer 1

I think the only thing you can do is to add [font="Courier New"]AND Status <> 1[/font] to the WHERE clause, so you don't re-update rows that already have the value (unless you are explicitly trying to fire an update trigger)

Eddie Wuerch
MCM: SQL

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

Can rows be 0 or negative? If not, you could make it status > 1.

Or do two updates with > 1 and < 1 as the clauses, which could run quicker.

Kent Waldrop Hall of Fame Points: 3064 More actions · Answer 3

If you are thinking of addin the STATUS <> 1 clause and the status column can contain nulls you might want to try ( STATUS <> 1 or STATUS IS NULL ) instead.