How to Create Database in SQL Server
Channel: Data Science Center
Date: 2022-03-17

How to create database in sql server (SSMS)
-Open SSMS
-CONNECT Database engine


CREATE DATABASE HRDB;
GO

USE HRDB;
GO

CREATE TABLE EMPLOYEES
(
ID INT IDENTITY PRIMARY KEY, 
First_Name varchar(20), 
Last_Name varchar(30) not null, 
email varchar(30) unique, 
salary int
);
GO

INSERT INTO EMPLOYEES (First_Name, Last_Name, email, salary) 
VALUES ( 'Smith', 'Ellen', 'selen@gmail.com', 40000);
GO

SELECT * FROM EMPLOYEES;