What do you expect from the following code? Will the block inside if be executed?
The statments inside If will never be executed because it will always evaluate false. The reason it equal (=) operator is not compatible with NULL. To compare NULL value, use IS operator. To fix the above we can write
Or we can use ISNULL operator to convert NULL into a value