SQL Server: Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
It’s strongly recommended to use any command-line tool(CLI) like terminal, cmd to run following queries and commands.
Before getting started MS SQL Server should be installed in the local system.
- Hit listed command to get connect with SQL Server.
sqlcmd -S localhost -U SA -P "<password>"
- Issue listed queries to create a database name called ‘geek’.
> CREATE DATABASE geek; > GO
- To use created data issue listed queries.
> Use <your database name>; > GO
- Issue listed queries to create a table name called ‘student’ with three fields id, firstname and lastname.
> CREATE TABLE student (id INT, firstname NVARCHAR(30), lastname NVARCHAR(30)); > GO
- Issue listed queries to insert some values into table ‘student’.
> INSERT INTO student VALUES (1, 'Stephen', 'Hawking'); > INSERT INTO student VALUES (2, 'Isaac', 'Newton'); > INSERT INTO student VALUES (3, 'Chandrasekhara Venkata', 'Raman'); > GO
- To check entries of table issue listed queries.
> SELECT * from student; > GO
Before getting started Node.js should be installed in the local system.
- To create Node.js environment issue following command.
- Express allows us to set up middlewares to respond to HTTP Requests.
npm install express --save
- Microsoft SQL Server client give us functionality to connect with SQL server.
npm install mssql --save
To begin with Node.js part, we need to create our server file server.js in our local system.
Run server.js file using the following command:
After executing the above command, you will see the following output on your console:
Server is listening at port 5000...
Now hit the url http://localhost:5000/ in the local browser.