How to Create Database in SQL Server

Channel Avatar
Comment
X
Share
How to Create Database in SQL Server
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;

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *