SQL 2000 Set Query

Question

Hi,

I have a SQL 2000 server with a database (ITinventory) and a table which is also called ITinventory. I would like to create a query which will look at the field 'Status', if the status is 'disposed' then I would like to set a 'location' field to 'disposed'.

Many thanks

Answer 1

UPDATE ITInventory SET Location = 'disposed' WHERE Status = 'disposed'

This SQL is making various assumptions otherwise not clarified in the OP...

Answer 2

update ITinventory
set location='disposed'
where status ='disposed'

Answer 3

UPDATE ITinventory
SET location = 'disposed'
WHERE status = 'disposed'

Answer 4

Try this.

UPDATE ITInventory SET Location = 'disposed' 
WHERE Status = 'disposed' AND Location != 'disposed'

Greets Flo

Answer 5

update 
    ITinventory 
set 
    Location = Status 
where 
    Status = 'Disposed'