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;
Watch video How to Create Database in SQL Server online, duration hours minute second in high quality that is uploaded to the channel Data Science Center 17 March 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 260,396 times and liked it 1.2 thousand visitors.
