sqlserver--Empty value Processing

SELECT * FROM Tblstudent

--Query All age is null student information

--null value cannot be compared using = or <>

--unknown

--The null value must be determined using is NULL or is not NULL

SELECT * from tblstudent where tsage is null

SELECT * FROM Tblstudent where tsage=null

--Check with all ages NOT NULL students

SELECT * FROM Tblstudent where tsage<>null

SELECT * from tblstudent where tsage are NOT null

SELECT * FROM Tblstudent where tsage=25

SELECT * FROM Tblstudent where tsage<>25

--Any value that is evaluated with NULL, the resulting result or null

Select 2000+null

sqlserver--Empty value Processing