Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
用 SQL LONG VARCHAR 数据类型设置指定消息属性。
消息发送后就不能再更改此属性。
在以下示例中,创建一条消息,设置字符串型属性 mystringproperty1 和 mystringproperty2,然后将消息发送到地址 clientid\queuename:
begin declare @msgid varchar(128); set @msgid = ml_qa_createmessage(); call ml_qa_setstringproperty( @msgid, 'mystringproperty1', 'c:\\temp' ); call ml_qa_setstringproperty( @msgid, 'mystringproperty2', 'first line\nsecond line' ); call ml_qa_putmessage( @msgid, 'clientid\queuename' ); commit; end