<!-- START doctoc generated TOC please keep comment here to allow auto update -->
<!-- DON'T EDIT THIS SECTION, INSTEAD RE-RUN doctoc TO UPDATE -->
**Table of Contents** *generated with [DocToc](https://github.com/thlorenz/doctoc)*
- [Supported SQL Server Versions](#supported-sql-server-versions)
- [Encoding Support](#encoding-support)
- [Connection Preview Support](#connection-preview-support)
- [SQL Query Dataset Support for SQL](#sql-query-dataset-support-for-sql)
- [Supported Authentication Methods for Connecting to SQL Server](#supported-authentication-methods-for-connecting-to-sql-server)
- [Unsupported Field Types](#unsupported-field-types)
<!-- END doctoc generated TOC please keep comment here to allow auto update -->
### Supported SQL Server Versions
2016, 2017
### Encoding Support
Automatically recognizes the encoding of SQL Server, no need to set it manually.
### Connection Preview Support
Supports regular tables, does not support views or other special tables.
### SQL Query Dataset Support for SQL
Only supports SELECT statements, supports all SELECT related features supported by the connected SQL Server, users need to ensure the syntax complies with SQL Server standards.
### Supported Authentication Methods for Connecting to SQL Server
Supports username and password methods, does not support SSL authentication.
### Unsupported Field Types
The following types of columns from SQL Server tables cannot be processed correctly. If you need other fields from this table, you can enter a select statement in the SQL query that does not include these fields.
- hierarchyid
- rowversion
- sql_variant
- xml
- geometry
- geography