[Savigo] You organize your data. Now organize your savings.
Set savings goals, track your progress, and stay on course.
This tutorial series shows you how to interact with the SQL Server from Node.js using the mssql package.
The mssql package has the following main features:
- Multiple authentication methods: supports Windows and SQL Server Authentication, providing flexibility for connecting to SQL Server.
- Connection pooling: efficiently manages multiple database connections, enhancing database performance and server resource utilization.
- Parameterized queries: offers a secure way to execute queries with external inputs, allowing you to prevent SQL injection attacks.
- SQL queries and stored procedures: allows you to execute SQL queries and stored procedures, covering a wide range of SQL Server operations.
- Streaming: supports large result sets by streaming data in chunks, helping reduce memory consumption.
- Transaction Management: supports transaction handling, ensuring data integrity and consistency for complex operations.
- Detailed error handling and logging: provides detailed error handling and logging features, making troubleshooting easier.
You should follow the tutorial in sequence for the best experience.
Section 1. Getting Started #
- Connecting to the SQL Server – show you how to create a Node.js program that connects to the SQL Server.
Section 2. Inserting Data #
- Insert data into a table – show you how to insert data into a table in SQL Server from Node.js
- Import a CSV file into a table – learn how to read data from a CSV file and import it into a table in the SQL Server.
- Bulk Insert – discover how to perform a bulk insert in SQL Server from Node.js application.
Section 3. Updating Data #
- Update data from a table – learn how to update data from a table from Node.js
Section 4. Querying Data #
- Select data from a table – Guide you on how to select one or more rows from a table in Node.js
- Pagination – Show you how to break up a large dataset into smaller chunks (pages) using FETCH and OFFSET clauses.
Section 5. Deleting Data #
- Delete data from a table – Show you how to delete data from a table in SQL Server from a Node.js application.
Section 6. Handling Transactions #
- Perform a transaction – learn how to perform an SQL Server transaction from Node.js.
Section 7. Calling Stored Procedures #
- Call a stored procedure – How to call a stored procedure from Node.js.
- Call a stored procedure with OUTPUT parameters – Show you how to call a stored procedure that has an OUTPUT parameter.
Was this tutorial helpful?
Yes No
![[Savigo]](https://www.duypham.app/wp-content/uploads/2026/08/savigo-logo-mark.svg){kind=link}
![[Creating a BookStore Database in SQL Server]](https://www.sqlservertutorial.net/wp-content/themes/evolution-2/img/left.svg){kind=link}
![[Node.js SQL Server: Connect]](https://www.sqlservertutorial.net/wp-content/themes/evolution-2/img/right.svg){kind=link}