asked
Insert data into a queue
I am trying to insert data into queue. The stored procedure fire_event will be used for this purpose. When ever this stored procedure is called, it should insert that data into the queue.. Below is the query and variables that will be passed from the stored procedure. Can some one tell me how to use this stored procedure to insert data in a queue in SQL Server. I want to replace the action of inserting into a table event_type by inserting it directly into a queue. Thanks BEGIN INSERT event_type VALUES (@p_message_id,@p_event_type,@p_classifier, @p_event_time,@p_correlation_id,@p_person_id,@p_channel_id, @p_source_address_id,@p_agent_user, @p_agent_channel_id,@p_device_os,@p_device_os_version, @p_device_manufacturer,@p_device_model,@p_product_id, @p_event_source,@p_event_version, @p_node_id,@p_user_agent_string,@p_event_data) END
DECLARE @h UNIQUEIDENTIFIER ,@msg XML = ( SELECT @p_message_id ,@p_event_type ,@p_classifier ,@p_event_time ,@p_correlation_id ,@p_person_id ,@p_channel_id ,@p_source_address_id ,@p_agent_user ,@p_agent_channel_id ,@p_device_os ,@p_device_os_version ,@p_device_manufacturer ,@p_device_model ,@p_product_id ,@p_event_source ,@p_event_version ,@p_node_id ,@p_user_agent_string ,@p_event_data FOR XML PATH('record') ) BEGIN DIALOG CONVERSATION @h FROM SERVICE [fromService] TO SERVICE 'toService' ON CONTRACT myContract WITH ENCRYPTION = OFF
9 People are following this question.
