Function Points (FPA) Interview Questions and Answers (1) - Page 1

What is the output of below sql query? declare @str varchar(10); set @str = 'Hello'; select ISNULL(@str,'Hello World');

Output would be Hello.

As IsNull checks 1st arguments,if the first argument value is null then returns second argument values.

In above query, @str is assigned a Hello,so ISNull will omit the second parameter value and return 1st parameter value that is Hello.
Found this useful, bookmark this page to the blog or social networking websites. Page copy protected against web site content infringement by Copyscape

 Interview Questions and Answers Categories