2018-08-11

ALTER DATABASE bh20180529 SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE bh20180529 SET ENABLE_BROKER;

ALTER DATABASE khzf2 SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE khzf2 SET ENABLE_BROKER;

select * from Employee

select * from

select * from UpdateManage

--update UpdateManage set NEW_VERSION=18

ALTER DATABASE bh20180529 SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE bh20180529 SET DISABLE_BROKER;

ALTER DATABASE khzf SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE khzf SET DISABLE_BROKER;

select * from UpdateManage

update bh.dbo.UpdateManage set NEW_VERSION=75