SQL Server Query Command

Question

I have an SQL database table, I want to find everything in a table where the 'Room' says 'DISPOSED', Insert 'DISPOSED' into the 'Status' field and then delete the entry in 'Room'.

Basically moving the entry from one field to another (if the 'Room' field has 'DISPOSED' in it)

Hope this makes sense.

Thanks for any help.

Salil · Accepted Answer · 2010-05-05 08:31:44Z

2

Update table_name SET room='', Stauts='DISPOSED' where Room='DISPOSED'

OR

Update table_name SET room=null, Stauts='DISPOSED' where Room='DISPOSED'

answered May 5, 2010 at 8:31

Salil

47.7k22 gold badges127 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TechTravelThink · Accepted Answer · 2010-05-05 08:31:53Z

0

The SQL is

UPDATE table SET status = room, room = null WHERE room = 'DISPOSED'

answered May 5, 2010 at 8:31

TechTravelThink

3,0943 gold badges21 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQL Server Query Command

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related