The forum will be down for maintenance at some point from Friday, August 24 at 19:00 EDT until Sunday, August 26 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

Hi again,

is it possible to select more than one value (like this:)

SELECT PROPERTY ( 'value1','value2' );


asked 02 Jan '16, 10:29

pmiller's gravatar image

accept rate: 37%

edited 04 Jan '16, 10:20

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

SELECT PROPERTY ('NumPhysicalProcessors'), PROPERTY('NumPhysicalProcessorsUsed');

and if you really need only one resulting value, you can concat the values as you like, say

SELECT PROPERTY ('NumPhysicalProcessors') || '/' || PROPERTY('NumPhysicalProcessorsUsed') AS myResult;
permanent link

answered 03 Jan '16, 09:05

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

edited 03 Jan '16, 09:08

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,
  FROM sa_eng_properties()
 WHERE sa_eng_properties.PropName IN ( 'NumPhysicalProcessors', 'NumPhysicalProcessorsUsed' )
 ORDER BY sa_eng_properties.PropName;


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
permanent link

answered 02 Jan '16, 10:59

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 02 Jan '16, 10:29

question was seen: 627 times

last updated: 04 Jan '16, 10:20