Replace Blank value into NULL or N/A.
How can manage NULL value in SQL server ?
1188
17-Sep-2018
Updated on 17-Sep-2018
Anonymous User
17-Sep-2018The different types of NULL values in Database like -
Blank value.
Empty value.
Zero value.
Optional value.
Invalid value.
void value.
Nothing value.
Missing value.
The lowest value.
Ignorable value.
1). Use Ascending order
2). -- Use descending order
3). Null in GroupBy
4). Case expression
5). Using COALESCE
6). ---Return 'N/A' if the name is NULL
About to NULL value's facts,it is not equal to or similar as any value
it is not greater than, less than or different from any type of value
The null value is not equal to NULL itself.
it is not greater than, less than or different from NULL values.