CONCAT and NULL - SQL in Sixty Seconds 123
What will be the result of the SELECT CONCAT (NULL, NULL, NULL) statement? It is very important to understand how Plus(+) Operator works differently from the CONCAT function.
Here is the associated blog post: https://blog.sqlauthority.com/2020/09/12/concat-and-null-sql-in-sixty-seconds-123/
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
0:00 Intro
0:12 Real World Scenario
0:33 Demo for CONCAT and NULL
1:12 Summary
1:38 Performance Result
#SQLServer #PerformanceTuning #SQLAuthority
Видео CONCAT and NULL - SQL in Sixty Seconds 123 канала Pinal Dave
Here is the associated blog post: https://blog.sqlauthority.com/2020/09/12/concat-and-null-sql-in-sixty-seconds-123/
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
0:00 Intro
0:12 Real World Scenario
0:33 Demo for CONCAT and NULL
1:12 Summary
1:38 Performance Result
#SQLServer #PerformanceTuning #SQLAuthority
Видео CONCAT and NULL - SQL in Sixty Seconds 123 канала Pinal Dave
Комментарии отсутствуют
Информация о видео
11 сентября 2020 г. 15:29:12
00:01:47
Другие видео канала
T-SQL Errors and Reactions Demo - SQL in Sixty Seconds #005
Install MongoDB on Windows - SQL in Sixty Seconds 091
Priority Boost and Performance - SQL in Sixty Seconds 131
Schema Change Reports - SQL in Sixty Seconds #078
T-SQL Constructs - += and *= - SQL in Sixty Seconds #009
Count Table in Cache - SQL in Sixty Seconds 149
Negative Identity Column - SQL in Sixty Seconds 101
Compressed Backup - Performance - SQL in Sixty Seconds 196
Queries Using Specific Index - SQL in Sixty Seconds 180
T-SQL Constructs - Declaration and Initialization - SQL in Sixty Seconds #003
TOP DISTINCT - Epic Confusion - SQL in Sixty Seconds 141
Transfer Schema of Table - SQL in Sixty Seconds 152
Installing SQL Server 2012 RTM
Impact of DBCC DROPCLEANBUFFERS on Memory - SQL in Sixty Seconds #085
Trim Function in SQL Server - SQL in Sixty Seconds #040
Introduction to SQL Server Security - SQL in Sixty Seconds #011
Code Comments - SQL in Sixty Seconds #059
MAX Columns Ever Existed in Table - SQL in Sixty Seconds 182
Most Used Database Files - SQL in Sixty Seconds 190
Excel - SUM vs SUBTotal - SQL in Sixty Seconds 167
Install SQL Server 2019 - SQL in Sixty Seconds 092
