Session : 2 : Creating and querying part of a table
CREATE TABLE use TESTOUT_DB go create table tbl_Employee ( Employee_Number varchar(20), Employee_FirstName varchar(20), Employee_MiddleName varchar(20), Employee_LastName varchar(20), Employee_Government varchar(20), Data_of_Birth date ) Second one use TESTOUT_DB go create table tbl_Employee_1 ( Employee_Number varchar(20) NOT NULL, Employee_FirstName varchar(20) NOT NULL, Employee_MiddleName varchar(20) NULL, -- you can have a blank for a middle name Employee_LastName varchar(20) NOT NULL, Employee_Government INT NOT NULL, Data_of_Birth date ) 57 : ADDING ADDITIONAL TABLE
Comments
Post a Comment