SoftadminApi.AzureServiceBus_EnqueueMessage

 Show all Hide all

Example

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;
Type: Stored procedure
Area of use: API

Parameters:

@AzureServiceBusMessageQueueIdOut optional bigint
@Body optional varbinary
The body of the message.
Exactly one of @Body and @BodyText must be set.
@BodyText optional nvarchar
The body of the message.
Exactly one of @Body and @BodyText must be set.
@ContentType mandatory varchar
The content type of the message.
@CorrelationId optional varchar
The correlation id for the message.
@QueueName optional varchar
The queue to send the message to.
Exactly one of @QueueName and @TopicName must be set.
@ServiceBusName optional varchar
The name of the service bus to use (as registered in Admin > Azure Service Bus). If omitted, the default service bus will be used.
@Subject optional nvarchar
The subject of the message.
@TopicName optional varchar
The topic to send the message to.
Exactly one of @QueueName and @TopicName must be set.

Resultsets:

Resultset: #MessageExtraProperties

Repeat mode: repeated zero or one time
Row count: zero or more rows

Columns:

Key mandatory string
Custom property name.
Value mandatory sql_variant
Custom property value.