August 18, 2011

ISNULL function in SQL Server

image

We have Employee table it has some NULL entries for salary.
I want to convert this one and show it as 0.
Yes we can do so we have ISNULL function in SQL Server.

image

You can see now NULL entries are coming as 0.
That’s It.
Enjoy Reading.

No comments:

Post a Comment