Create the database

Create the database

Let us create a database called StudentDB along with a Student table using Visual Studio or SSMS

USE master;
GO

CREATE DATABASE StudentDB;
GO

USE StudentDB;
GO

CREATE TABLE Student(
 Id INT PRIMARY KEY,
 Name VARCHAR(100),
 Email VARCHAR(50),
 Mobile VARCHAR(50)
)
GO

INSERT INTO Student VALUES (101, 'Anurag', '[e-mail]', '1234567890')
INSERT INTO Student VALUES (102, 'Priyanka', '[e-mail]', '2233445566')
INSERT INTO Student VALUES (103, 'Preety', '[e-mail]', '6655443322')
INSERT INTO Student VALUES (104, 'Sambit', '[e-mail]', '9876543210')
GO

Verify creation

We could use a select query to verify if the data has been created