Practice Activity Replacing NULL and blank values in Microsoft SQL Server

YOUR LINK HERE:

http://youtube.com/watch?v=i2nAiylbCEc

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)

#############################

New on site