如何在SQL Server 2005中使用Service Broker内部激活

CREATE PROCEDURE usp_RecordSaleMessage

AS 

BEGIN


            SET NOCOUNT ON;
            DECLARE @Handle UNIQUEIDENTIFIER;
            DECLARE @MessageType SYSNAME;
            DECLARE @Message XML
            DECLARE @SaleDate DATETIME 
            DECLARE @SaleAmount MONEY
            DECLARE @ItemsSold INT;


      
            RECEIVE TOP (1) 
                  @Handle = conversation_handle,
                  @MessageType = message_type_name, 
                  @Message = message_body
            FROM [SalesQueue];
            
                
            IF(@Handle IS NOT NULL AND @Message IS NOT NULL)
            BEGIN
                  SELECT @SaleDate = CAST(CAST(@Message.query('/Params/SaleDate/text()') AS NVARCHAR(MAX)) AS DATETIME)
                  SELECT @SaleAmount = CAST(CAST(@Message.query('/Params/SaleAmount/text()') AS NVARCHAR(MAX)) AS MONEY)
                  SELECT @ItemsSold = CAST(CAST(@Message.query('/Params/ItemsSold/text()') AS NVARCHAR(MAX)) AS INT)


                  INSERT INTO Sales(SaleDate ,SaleAmount ,ItemsSold )
                  VALUES(@SaleDate,@SaleAmount,@ItemsSold);
            END

END

GO