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