a question using OR - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

a question using OR

Author

Topic

phaze
Starting Member

42 Posts

Posted - 2008-12-05 : 16:14:50

i have the following code:

UPDATE loyalty_offer_cntl
SET end_date = '2009-01-24 23:59:59.997',
audit_id = @audit_id,
database_action = 'U'
WHERE
loyalty_offer_code = 'BC102-EM'
or loyalty_offer_code = 'BC103-EM'
or loyalty_offer_code = 'BC104-EM'
or loyalty_offer_code = 'BC105-EM'

now my question is that if i use OR will this update the end_date to my specified date for all three different loyalty_offer_code?

I previously had it as this code below but i figured i could simplify my coding.

UPDATE loyalty_offer_cntl
SET mclu_num = 798149,
audit_id = @audit_id,
database_action = 'U'
WHERE loyalty_offer_code = 'BC102-EM'

UPDATE loyalty_offer_cntl
SET mclu_num = 798149,
audit_id = @audit_id,
database_action = 'U'
WHERE loyalty_offer_code = 'BC103-EM'

UPDATE loyalty_offer_cntl
SET mclu_num = 798150,
audit_id = @audit_id,
database_action = 'U'
WHERE loyalty_offer_code = 'BC104-EM'

UPDATE loyalty_offer_cntl
SET mclu_num = 798150,
audit_id = @audit_id,
database_action = 'U'
WHERE loyalty_offer_code = 'BC105-EM'

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-12-05 : 16:52:04

yes, you can also use IN(...) as
loyalty_offer_code in ('BC102-EM','BC103-EM'...)