UPDATE TBL_STOCK
SET unit_price = '280.00'
WHERE (part_code = '002-540001') or (part_code = '004-560003')
Tag : Ms SQL Server 2008
Date :
2013-05-16 10:17:03
By :
wit
View :
1072
Reply :
3
No. 1
Guest
Code (SQL)
UPDATE TBL_STOCK
SET unit_price=case when part_code='002-540001' then 280 when part_code='004-560003' then 160 else unit_price end
WHERE part_code <> ''
Load balance : Server 02
