Output would be Hello World.
As IsNull checks 1st arguments,if it's null then returns second argument values.
And in above query @str has no value means @str has not been assigned any value.
so it will return 2nd argument value that is Hello World
Asked In: Many Interviews |