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)
En esta página del sitio puede ver el video en línea Practice Activity: Replacing NULL and blank values in Microsoft SQL Server de Duración hora minuto segunda en buena calidad , que subió el usuario SQL Server 101 25 agosto 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 17,255 veces y le gustó 109 a los espectadores. Disfruta viendo!
