»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Question
What is the difference between isnull and coalesce? | | isnull returns whether the particular column value is null or not.
coalesce returns the not null value in the given columns.
coalesce (column1,column2,column3) | | Correction - ISNULL(column or value, "New Value") - This function takes 2 parameters.
1. first is the column name of value that need to be checked agains null value and used to return value if it is not null,
2. second parameter is the default value that need to be returned if the value of first parameter is null.
Functionality:
If the value of first parameter is null, then the second parameter is returned as such, and if the value of first parameter is not null then the value of first parameter is returned.
| | Correction - ISNULL(column or value, "New Value") - This function takes 2 parameters.
1. first is the column name of value that need to be checked agains null value and used to return value if it is not null,
2. second parameter is the default value that need to be returned if the value of first parameter is null.
Functionality:
If the value of first parameter is null, then the second parameter is returned as such, and if the value of first parameter is not null then the value of first parameter is returned.
- Anuj ( anuj.mca@gmail.com ) +91 9313499294 |
Answer Question
|