Department (Dept) Sample Data

Please Copy the below Query and run on your SSMS.


/* Droping the Existing Dept Table: */
DROP TABLE IF EXISTS tbl_Dept;

/* Creating New Dept Table: */
CREATE TABLE tbl_Dept(
tbl_Deptno INT NOT NULL PRIMARY KEY
, DName VARCHAR(50) NOT NULL
, Location VARCHAR(50) NOT NULL);

/* Inserting Data into Dept Table: */
INSERT INTO tbl_Dept VALUES 
 (10,'Accounting','New York')
,(20,'Research','Dallas')
,(30,'Sales','Chicago')
,(40,'Operations','Boston');

/*cSeleting Inserted Data */
SELECT * FROM tbl_Dept

Click Here for : Employee Table Sample Data

Please comment below