Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the property number of the property with the supplied property-name.
PROPERTY_NUMBER( property-name )
A property name.
Each property has both a number and a name, but the number is subject to change between releases, and should not be used as a reliable identifier for a given property. When either property number or property name can be used, it is preferable to use the property name. Always use the PROPERTY_NUMBER function to ensure that the property number is current for the server being used.
Not in the standard.
The following statement returns the property number of the PAGESIZE property as an integer:
SELECT PROPERTY_NUMBER( 'PAGESIZE' );