How to Create Database in SQL Server

Опубликовано: 05 Февраль 2025
на канале: SQL POINT

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;