dat340-文庫(kù)吧資料
2024-10-07 21:45本頁(yè)面
【正文】 ” delivery 。) process msg … RECEIVE TOP(1) conversation = conversation_handle, END CONVERSATION conversation Resources Technical Chats and Webcasts Microsoft Learning and Certification MSDN amp。RECEIVE TOP(1) conversation = conversation_handle, msgType = message_type_name, msg = message_body IF (msgType = 39。 ON CONTRACT [//] SEND ON CONVERSATION dialog_handle MESSAGE TYPE [//] (msgString) to Receive a Message Declare variables for storing message details 1 Call RECEIVE statement 2 Check the message type, and process accordingly 3 If finished conversation, call END CONVERSATION 4 DECLARE conversation UNIQUEIDENTIFIER DECLARE msg NVARCHAR(MAX), msgType NVARCHAR(256) DECLARE conversation UNIQUEIDENTIFIER DECLARE msg NVARCHAR(MAX), msgType NVARCHAR(256) 。 群集或數(shù)據(jù)庫(kù)鏡像 確定隊(duì)列中的操作非常簡(jiǎn)單 在提交事務(wù)時(shí)只需寫入單個(gè)日志 可靠的消息傳送通常將消息從傳送隊(duì)列傳送到接收隊(duì)列 隊(duì)列讀取器管理 Activation 具體實(shí)現(xiàn)與演示 Service Broker 系統(tǒng)架構(gòu) SQL Server Object Description Message Type Defines valid messages for exchange between services Contract Specifies type of messages and their direction in a conversation, initiator or target Queue Stores messages before sending and after receipt as result set Service Program The part of a service broker application that reads messages from a queue and processes them. Service Addressable endpoint for service munication Ser
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1