Introduction:
Here
I will explain how to write a query to return default value if column contains
null value in SQL
Server.
Description:
In
previous articles I explained how to delete null or empty values from datatable in SQL
Server and many articles relating to SQL
Server.
Now I will explain how to write a query to return default if column contains
null value in SQL
Server.
For that first design one table (UserInfo)
in database and enter data like as shown below