In this section, we are going to create the database for our app containing the tables we need along with stored procedures to interact with those tables.
Implementing the database
Creating the database
We are going to create the database using SQL Server Management Studio (SSMS) by carrying out the following steps:
- Open SSMS and connect to the SQL Server instance:
- In Object Explorer, right-click on Databases and click on the New Database... option.
- Enter QandA for the name for the database and click OK:
- After the database is created, we'll see it listed in Object Explorer:
Nice and easy!