Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
用 SQL BIT 数据类型设置指定消息属性。
消息发送后就不能再更改此属性。
在以下示例中,创建一条消息,设置布尔型属性 mybooleanproperty1 和 mybooleanproperty2,然后将消息发送到地址 clientid\queuename:
begin declare @msgid varchar(128); set @msgid = ml_qa_createmessage(); call ml_qa_setbooleanproperty( @msgid, 'mybooleanproperty1', 0 ); call ml_qa_setbooleanproperty( @msgid, 'mybooleanproperty2', 1 ); call ml_qa_putmessage( @msgid, 'clientid\queuename' ); commit; end