How to Create Database in SQL Server
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', '[email protected]', 40000);
GO
SELECT * FROM EMPLOYEES;