Using ISNULL to Replace Missing Values in your Queries | Essential SQL

2 года назад

4,061 Просмотров

The ISNULL function is a great way to replace NULL with another value. Use it to dress up your query output or to help with calculations.

For instance you can use ISNULL to "switch" a NULL to a 0, if you choose!
--------------------
This video is part of my Beginner Learning series. If you're interested in learning SQL subscribe to @Essential SQL and then check out our Beginner Learner Playlist.

Of course, I also encourage you to visit https:\\www.essentialsql.com to learn even more!

Тэги:

#Learn_SQL #SQL_for_Beginners #SQL_Training #SQL_Server #EssentialSQL #null #NULL_Values #ISNULL

Скачать видео

Комментарии:

@aashishmalhotra - 29.07.2022 15:05

Found your channel today and its best thing happened today

Ответить

@simplesql1408 - 06.09.2021 16:48

Great tutorial! I didn't know about the typing issue you outlined. I've read that if given the choice, you should prefer to use COALESCE instead of ISNULL. Maybe this is why!

Ответить

@MrJpiarull - 05.09.2021 03:41

You can also add in As "column name" to call it whatever you want, though not all that recommended, as spaces in any field name will make SQL not play so nice later on

Ответить