This project has moved. For the latest updates, please go here.

QueryCommand Element

SQL Query returning only one column as string (VARCHAR).

SELECT DISTINCT
       [City]
  FROM [dbo].[DimGeography]
 WHERE [StateProvinceCode] = 'CA'

- or -

xPath statement return string

Syntax

<InjectionDefinition>
  <QueryCommand>...</QueryCommand>
</InjectionDefinition>
Element Characteristics

Characteristic

Description

Data type and length

string

Default value

- None -

 
Element Relationships

Relationship

Description

Parent elements

InjectionDefinition

Child elements

- None -

Last edited Apr 14, 2014 at 3:51 PM by marcodellacasa, version 3