SQL Test Queries Field Selection

SQL Test Query - Field Selection #001

Using * to select all fields

1. "SELECT * FROM List1"

SQL Test Query - Field Selection #002

Selecting two fields (with bad syntax - not wrapping field name with spaces in [ ])

1. "SELECT Field1, Field 2 FROM List1"

Uncaught [camlsql] Invalid syntax: Field 2

SQL Test Query - Field Selection #003

Selecting two fields (wrapping [Field 2] correctly)

1. "SELECT Field1, [Field 2] FROM List1"

<View>
    <ViewFields>
        <FieldRef Name="Field1" />
        <FieldRef Name="Field_x0020_2" />
    </ViewFields>
</View>

SQL Test Query - Field Selection #004

More complex encoding of field names

1. "SELECT Field1, [Field 2], [Åldersbenämning] FROM List1"

<View>
    <ViewFields>
        <FieldRef Name="Field1" />
        <FieldRef Name="Field_x0020_2" />
        <FieldRef Name="_x00c5_ldersben_x00e4_mning" />
    </ViewFields>
</View>