# MSSql components

| [tMSSqlBulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlbulkexec) | Offers gains in performance while executing the Insert operations to a Microsoft<br>SQL Server database. |
| --- | --- |
| [tMSSqlClose](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlclose) | Closes a transaction in the MSSql databases. |
| [tMSSqlColumnList](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlcolumnlist) | Lists all column names of a given MSSql table. |
| [tMSSqlCommit](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlcommit) | Commits in one go, using a unique connection, a global transaction instead of doing<br>that on every row or every batch and thus provides gain in performance. |
| [tMSSqlConnection](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlconnection) | Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs. |
| [tMSSqlInput](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlinput) | Executes a DB query with a strictly defined order which must correspond to the<br>schema definition. |
| [tMSSqlLastInsertId](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqllastinsertid) | Retrieves the last primary keys added by a user to a MSSql table. |
| [tMSSqlOutput](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqloutput) | Executes the action defined on the table and/or on the data contained in the table,<br>based on the flow incoming from the preceding component in the Job. |
| [tMSSqlOutputBulk](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqloutputbulk) | Prepares the file to be used as parameter in the INSERT query to<br>feed the MSSql database. |
| [tMSSqlOutputBulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqloutputbulkexec) | Gains in performance during Insert operations to a Microsoft SQL Server<br>database. |
| [tMSSqlRollback](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlrollback) | Cancels the transaction commit in the MSSql database and thus avoids to commit<br>part of a transaction involuntarily. |
| [tMSSqlRow](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlrow) | Acts on the actual DB structure or on the data (although without handling data). |
| [tMSSqlSP](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqlsp) | Offers a convenient way to centralize multiple or complex queries in a database and<br>calls them easily. |
| [tMSSqlTableList](https://help.qlik.com/talend/r/en-US/7.3/components/mssql/tmssqltablelist) | Lists the names of a given set of MSSql tables using a select statement based on<br>a Where clause. |