How to Create Database in SQL Server

preview_player
Показать описание
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)
GO

SELECT * FROM EMPLOYEES;
Рекомендации по теме
Комментарии
Автор

thanks for making this so easy for me, i have checked other tutorials on youtube it seems to be getting more confusing but yours was easy. subscribed😊

luxurylifestyle
Автор

Nice sir your explanation vision clear but your voice is not

mlkqled
Автор

THANK YOU sir it was a simple but effective

afifaafifa
Автор

Sir thanks for this u are the great sir😊

pehwqbe
Автор

It's a great source of learning. ❤❤❤❤.

IhrafKhan
Автор

Msg 2714, Level 16, State 6, Line 9
There is already an object named 'TableFood' in the database.
sir help me this bug

hoainguyenvan
Автор

sir what should i do i dont have adventureworkDW

fritzserrano
Автор

hello i have problem in my sql management studio whenever i input data/value in my database, it get repeated when i enter new values can someone help me?

bennetlamasan
Автор

I'm using same command but when executing, it show that database ' filename' already exist. Please help me with this. How to fix this problem?? Please help me

riyazahmad
Автор

why when I first start SSMS i cant connect direct to the server (Server name section is EMPTY) Please help im going to end my life soon...

L_