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