Hi again, is it possible to select more than one value (like this:)
Source http://dcx.sap.com/index.html#1201/en/dbadmin/server-properties-perfapp.html |
As Breck has stated, PROPERTY() is a function, so if you want to call it with several arguments, you simply have to call it once for each argument, such as
and if you really need only one resulting value, you can concat the values as you like, say
|
PROPERTY only returns one value because it is a function and that's what functions do. The sa_eng_properties() procedure returns a result set which can be manipulated in a variety of ways depending on how you like your multiple values presented... SELECT sa_eng_properties.PropName, sa_eng_properties.Value FROM sa_eng_properties() WHERE sa_eng_properties.PropName IN ( 'NumPhysicalProcessors', 'NumPhysicalProcessorsUsed' ) ORDER BY sa_eng_properties.PropName; PropName,Value 'NumPhysicalProcessors',1 'NumPhysicalProcessorsUsed',1 SELECT LIST ( sa_eng_properties.Value, ', ' ORDER BY sa_eng_properties.PropName ) AS "List of Properties" FROM sa_eng_properties() WHERE sa_eng_properties.PropName IN ( 'NumPhysicalProcessors', 'NumPhysicalProcessorsUsed' ); List of Properties 1, 1 |