Practice Activity: Replacing NULL and blank values in Microsoft SQL Server скачать в хорошем качестве

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)