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