CREATE TABLE #MessageExtraProperties
(
[Key] varchar(100) NOT NULL,
[Value] sql_variant NOT NULL
);
INSERT #MessageExtraProperties([Key], [Value])
VALUES ('MyCustomProperty', 17);
DECLARE @AzureServiceBusMessageQueueIdOut bigint;
EXEC SoftadminApi.AzureServiceBus_EnqueueMessage
@ServiceBusName = 'MyBus',
@QueueName = 'myqueue',
@BodyText = 'This is a message.',
@ContentType = 'text/plain',
@AzureServiceBusMessageQueueIdOut = @AzureServiceBusMessageQueueIdOut OUTPUT;
DROP TABLE #MessageExtraProperties;