Select from following answers:- IsNull function is used to replace null with specified value.
- Return type is same as input value.
- If supplied input contains any value,then IsNull returns first supplied input value.
- Data type of input_value and replacement_value must be the same.
- All Above
Above all statement is correct about IsNull function.
It has two argument as
Isnull(input_value,replacement_value);
For example:-
select ISNULL(1,'na'); --1
select ISNULL(null,1); --1
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator