捷信达报钟器解除房间绑定SQL语句

[landv]

--解锁房间绑定 
--设置 @s_roomno 的房间号后，执行即可解除绑定，然后再重新绑定即可。

declare @s_roomno varchar(30)
set @s_roomno = 'XXX'

delete cardlist where v_roomno = @s_roomno

update snroom 
set v_branchphone = ''
where v_roomno = @s_roomno