# 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="https://content.gitbook.com/content/yVpJJpVl37JA6NYorbNR/blobs/EcvC74zWvx1eXRNnBXRV/obrazek.png" alt=""><figcaption></figcaption></figure>