{"repo":"tediousjs/node-mssql","free":true,"listed":false,"github":"https://github.com/tediousjs/node-mssql","clone":"git clone https://github.com/tediousjs/node-mssql.git","description":"Microsoft SQL Server client for Node.js","language":"JavaScript","stars":2273,"topics":["javascript","nodejs","sql-server","mssql","tds"],"license":"MIT","category":"databases-storage","readme_excerpt":"node-mssql Microsoft SQL Server client for Node.js [![NPM Version][npm-image]][npm-url] [![NPM Downloads][downloads-image]][downloads-url] Supported TDS drivers: - [Tedious][tedious-url] (pure JavaScript - Windows/macOS/Linux, default) - [MSNodeSQLv8][msnodesqlv8-url] (Microsoft / Contributors Node V8 Driver for Node.js for SQL Server, v2-v5 native - Windows or Linux/macOS 64 bits only) Installation Tedious driver (default) MSNodeSQLv8 driver (optional) SQL Server prerequisites This package requires TCP/IP to connect to SQL Server, and you may need to enable this in your installation. Short Example: Use Connect String If you're on Windows Azure, add ?encrypt=true to your connection string. See docs to learn more. Parts of the connection URI should be correctly URL encoded so that the URI can be parsed correctly. Longer Example: Connect via Config Object Assuming you have set the appropriate environment variables, you can construct a config object as follows: Windows Authentication Example Using MSNodeSQLv8 Documentation Examples Async/Await Promises ES6 Tagged template literals Callbacks Streaming Connection Pools Configuration General Formats Drivers Tedious MSNodeSQLv8 Connections Pool Management Connection Validation ConnectionPool connect close Pool properties parseConnectionString Requests Request execute input output replaceInput replaceOutput toReadableStream pipe query batch bulk cancel Transactions Transaction begin commit rollback Prepared Statements PreparedStateme","default_branch":null,"files":null,"tree":[],"storefront":"/r/tediousjs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tediousjs/node-mssql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}