This functionality is only available for certain module packages.

You are here: EEC > BASE > Data sources > Data source objects > DatabaseDataSource > Microsoft SQL Server

Microsoft SQL Server

Here, all table and column names are treated as case-insensitive. The table and column names

can be in uppercase or lowercase letters.

Contrary to the spelling used in the database, the column names are supplied in the result in the same way as in the SQL statement:

..perform('select ARTIKELNUMMER from ARTIKEL').collect(x | x.ARTIKELNUMMER)
..perform('select Artikelnummer from Artikel').collect(x | x.Artikelnummer)

As for requests with an asterisk, all column names are supplied as specified in the database:

..perform('select * from Artikel').collect( x | x.Artikelnummer)

Note:

Microsoft Access behaves with SQL requests identically to Microsoft SQL Server.