As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for NULL. Now in this tip I would like to share one of the interesting setting for NULL. Although it is just for knowledge but don’t use it because it is deprecated in future version and …
We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we allow the data field to accept null.We think it will not affect anything. Actually , at some point this is not always true. According to Microsoft NULL is an Unknown value. It is not …
There are various functions available in SQL Server and it is good to know all of them you never know when they will be helpful to you. So lets start one by one. 1) LEN :- By the name it is clear that LEN function give length of the parameter For example :- DECLARE …
This is one the new feature in SQL Server 2012 by which you can concatenate values. The USP of the function is that it handle the NULL values also. means if you are concatenating values in which null also exists then it handle those null value also means it concatenates only those values which …
Problem: Sometimes, it might be possible that we need not null value only from particular columns and if all column have null value then we provide a default value. Lets understand this by a general and very interesting example suppose a friend come to your house and you want to give him a treat …