When a message is read, the message header and user properties can be processed by Transact-SQL application logic, using built-in SQL functions. These functions return:
The name of the nth property
The value of a named property
The type of a named property
The number of properties
A list of the properties
These built-in functions allow application logic to make processing decisions during runtime, based on the value of the message properties. The built-in functions are:
msgproplist
msgpropname
msgpropvalue
msgproptype
msgpropcount
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
