Practice Activity: Replacing NULL and blank values in Microsoft SQL Server
Showing a lack of data is not user-friendly. Let's see how we can change this.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
Normally data has at least one character. But what happens when you have either NULL data or blank data?
There are a variety of ways to change this data. In this video, we'll have a look at ISNULL, COALESCE, and CASE WHEN.
Why not try this as a Practice Activity? If you would like the starting code, here it is:
DROP TABLE IF EXISTS TextValues
CREATE TABLE TextValues
(txtField varchar(20) NULL)
INSERT INTO TextValues VALUES
('First value'),
('Second value'),
(''),
(NULL)
Смотрите видео Practice Activity: Replacing NULL and blank values in Microsoft SQL Server онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал SQL Server 101 25 Август 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 17,255 раз и оно понравилось 109 посетителям.
