Scribd
Upload
15 views1 page

SQL Employee Table Creation Guide

The document contains SQL commands to create an 'Employees' table with various fields including EmployeeID, FirstName, LastName, Email, DepartmentID, HireDate, and Salary. It also includes sample data insertion for five employees with their respective details. The table is designed to store employee information in a structured format.

Uploaded by

ankity9990
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
15 views1 page

SQL Employee Table Creation Guide

The document contains SQL commands to create an 'Employees' table with various fields including EmployeeID, FirstName, LastName, Email, DepartmentID, HireDate, and Salary. It also includes sample data insertion for five employees with their respective details. The table is designed to store employee information in a structured format.

Uploaded by

ankity9990
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

CREATE TABLE Employees (

EmployeeID INT PRIMARY KEY,


FirstName NVARCHAR(50),
LastName NVARCHAR(50),
Email NVARCHAR(100) UNIQUE,
DepartmentID INT,
HireDate DATE,
Salary DECIMAL(10, 2)
);

INSERT INTO Employees (EmployeeID, FirstName, LastName, Email, DepartmentID,


HireDate, Salary)
VALUES
(1, 'John', 'Smith', '[Link]@[Link]', 101, '2021-06-15', 75000.00),
(2, 'Jane', 'Doe', '[Link]@[Link]', 102, '2020-03-10', 85000.00),
(3, 'Michael', 'Johnson', '[Link]@[Link]', 101, '2019-11-22',
95000.00),
(4, 'Emily', 'Davis', '[Link]@[Link]', 103, '2022-01-05', 68000.00),
(5, 'William', 'Brown', '[Link]@[Link]', 102, '2018-07-19', 80000.00);

You might also like