SQL Server for Node.js

Microsoft SQL Server provides many features for data manipulation. Now you can access SQL Server from Node.js application. This book helps you how to get started with Node.js and SQL Server. It covers how to prepare your development environment.

***TOC***

1. Preparing Development Environment

2. Hello World - Connecting to Database Server

2.1 Database Configuration

2.2 Development Tools

2.3 Connectivity Testing

3. Database Table Operations

3.1 What are Table Operations?

3.2 Database Connection String

3.3 Inserting Data

3.4 Reading Data

3.5 Updating Data

3.6 Deleting Data

3.7 Finding Data

4. Stored Procedures

4.1 Creating Stored Procedure

4.2 Executing a Stored Procedure

4.3 Stored Procedure with Parameters

5. Working with Image and Binary Data

5.1 Image and Binary Data

5.2 Inserting Data

5.3 Reading Data

5.4 Deleting Data

6. Transactions

6.1 What is a Transaction?

6.2 Case 1 - Data Processing without Transaction

6.3 Case 2 - Data Processing with Transaction