CREATE TABLE EMPLOYEE
(FIRST_NAME CHAR(30) NOT NULL, -- THIS COLUMN WILL NOT ALLOW NULL VALUESLAST_NAME CHAR(30),-- THIS COLUMN WILL ALLOW NULL VALUES NOWAGE INT -- THIS COLUMN WILL ALLOW NULL VALUES NOW )GO-- FIRST SENARIO-- INSERT EMPTY RECORDS IN THE COLUMN VALUES TO SEE THE DIFFERENCE IN THE RESULTINSERT INTO [TESTING].[dbo].[EMPLOYEE]([FIRST_NAME]
,[LAST_NAME]
,[AGE])VALUES
('','','')GO
SELECT * FROM EMPLOYEE-- RESOLUTION
-- FIRST_NAME : WE USED '' IN THE FISRT ROW.THAT MEANS IT IS INSERTING SOME SPACE.
-- AGE : AS AGE DATATYPE IS INT BY DEFAUL IT WILL TAKE 0 WHILE WE INTSERT NO VALUE.
-- SECOND SENARIO
-- DONT INSERT ANY VALUE IN THE FIRST COLUMN TO SEE THE DIFFERENCE IN THE RESULTINSERT INTO [TESTING].[dbo].[EMPLOYEE]([LAST_NAME],[AGE]
)VALUES
(
'','')GO
SELECT * FROM EMPLOYEE--RESOLUTION
-- FIRST_NAME: AS FIRST NAME IS NOT ALLOWS NULL IT IS THROWING AN ERROR FOR THE ABOVE INSERT QUERY
-- THIRD QUERY
-- DONT INSERT ANY VALUE IN THE LAST_NAME AND AGE COLUMN TO SEE THE DIFFERENCE IN THE RESULTINSERT INTO [TESTING].[dbo].[EMPLOYEE](FIRST_NAME)VALUES
('')GO
SELECT * FROM EMPLOYEE
-- THIS IS THE DIFFERENCE BETWEEN NULL AND EMPTY VALUE IN A RECORDS
