CONCAT in sql server | [string Function] | CONCAT_WS | SQL Server Tutorial and learning SQL in 2020

This video shows an example of CONCAT and CONCAT_WS
#CONCAT #CONCAT_WS #JOININGSTRING #howtocancatestring

Concat is a function to join multiple strings without converting any data type like int or date
example select Concat('SQL',' ' , 'SERVER' , ' ', 2020)
result = SQL SERVER 2020
CONCAT_WS is advance of Concat in this function we dint have to define separate
again and again Example
select CONCAT_WS(' ' , 'SQL' , 'SERVER', 2020)
result =SQL SERVER 2020
here we have to define space only one time at the first expression and SQL server adds by default in every string

great tutorial to learn SQL Server and T-SQL with Examples and new videos in simple language