String Functions - Concat, Concat_Ws | CONCAT_WS in sql server | realtime use of concat_ws

preview_player
Показать описание
SQL server realtime use of concat_ws
string functions in sql server
----------------------------------------------------------------------------------------
------------------Query---------------------
Select ISNULL(FirstName+'-','')+ISNULL(MiddleName+'-','')+ISNULL(LastName,''),

CONCAT(ISNULL(FirstName+'-',''),ISNULL(MiddleName+'-',''),ISNULL(LastName,'')),

CONCAT_WS('-',Title,FirstName,MiddleName,LastName) ,

*
-----------------------------------------------------------------------------------------------

For SQL Quiz-

Find Us On FaceBook-
Рекомендации по теме
Комментарии
Автор

Wow.. I will now replace isnull with this function in my stored proc.. So helpful

chetalikekre