> For the complete documentation index, see [llms.txt](https://help.holixa.com/holixa-erp-picker/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.holixa.com/holixa-erp-picker/common-information/application-configuration/examples-of-connections-to-data-sources/ms-sql.md).

# MS SQL

An example of the settings for the MS SQL database is shown below.

**Settings `ConnectionString`**

{% code overflow="wrap" %}

```ini
ConnectionString=Server=(LocalDb)\LocalDBTesting; Database=MyTestDatabase; User ID=***; Password=***
```

{% endcode %}

**Settings `ConnectionSelectCommand`**

<pre class="language-ini" data-overflow="wrap"><code class="lang-ini"><strong>ConnectionSelectCommand=SELECT ID_, Group_, Number, Name01, Description_, Standard_, Material, Thickness FROM TestDataTable 
</strong></code></pre>

**Database preview**

<figure><img src="/files/RubAZE90ePIghmHrqlxG" alt=""><figcaption></figcaption></figure>