创建发送库的消息服务.sql

来自「sql broker service 实例」· SQL 代码 · 共 24 行

USE InitiatorDB;
GO

CREATE MESSAGE TYPE [//BothDB/2DBSample/RequestMessage]
       VALIDATION = none;
CREATE MESSAGE TYPE [//BothDB/2DBSample/ReplyMessage]
       VALIDATION = none;
GO


CREATE CONTRACT [//BothDB/2DBSample/SimpleContract]
      ([//BothDB/2DBSample/RequestMessage]
         SENT BY INITIATOR,
       [//BothDB/2DBSample/ReplyMessage]
         SENT BY TARGET
      );
GO


CREATE QUEUE InitiatorQueue2DB;

CREATE SERVICE [//InitDB/2DBSample/InitiatorService]
       ON QUEUE InitiatorQueue2DB;
GO