# tMSSqlInput

Executes a DB query with a strictly defined order which must correspond to the schema definition.

tMSSqlInput reads data and extracts fields based on a query from a Microsoft SQL Server database or a Microsoft Azure SQL database. Then it passes on the field list to the next component via a Main row link.

For more technologies supported by Talend, see [Talend components](https://help.qlik.com/talend/r/en-US/7.3/components/mssql).

### In this section

* [tMSSqlInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/mssql/tmssqlinput-standard-properties)

**Related concepts**

[Inserting data into a database table and extracting useful information from it](https://help.qlik.com/talend/en-US/components/7.3/mssql/tmssqlinput-tmssqloutput-tlogrow-inserting-data-into-database-table-and-extracting-useful-information-from-it-standard-component-the)