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, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 17,255 раз и оно понравилось 109 зрителям. Приятного просмотра!
