Begin Tran

Declare @hotelcd char(10)='HT17005257'

Select hotelcd, hotelnm from HEM037 where hotelcd=@hotelcd

select hotelcd, stsdpbobd from hem700 where hotelcd=@hotelcd
update HEM700 set stsdpbobd=NULL where hotelcd=@hotelcd
select hotelcd, stsdpbobd from hem700 where hotelcd=@hotelcd

Rollback