Gyan Pitara Forums

hello guyz,

well, whenever i work in sql server i gotta some kind of confusion with NULL and NOT NULL. so hopefully u all guys might goin' through this.. well here the solution simple and best......

Nulls is basically a special kind of marker by which sql server represent missing value.
well this example will give you the complete knowledge abt NULLS:
When we say that the height of a person is null, its means we know that height of a particular person is exists, but we don't know what it is..
in other words we don't know the exact height ,therefore we mark it as null, and we interpret that the mark means that we do not know what the real value is, finally the whole point is that they r not values and r not same as blank or zero.


this is just a little bit abt NULLS anyone have some other or new abt NULLS and NOT NULLS plz post it.
have a good day

Thanks Buddy