This is one of the new string functions introduced in SQL Server 2012. This function provides an easy way for the developers to concatenate the string values. Let us first see the syntax of this method:<\/p>\n
Syntax:<\/strong><\/p>\n CONCAT( string1, string2 [,stringN])<\/em><\/p>\n Here the parameters: string1, string2, … ,stringN are the string values which will be concatenated. This method requires\u00a0minimum\u00a0two arguments and max 254 arguments.<\/p>\n Let us understand this new CONCAT function\u00a0 with a simple example:<\/p>\n RESULT:<\/strong> Some of the important features about this function are: Let us see this with an example:<\/p>\n RESULT:<\/strong> In previous versions of SQL Server where if we are using ‘+’ to concatenate the values then we were\u00a0explicitly\u00a0need to convert them to string and then concatenate. To achieve the result as in the above SQL 2012 \u00a0example we were needed to write a Sql Statement like below with CAST\/CONVERT function:<\/p>\n 2) Null values are implicitly converted to an empty string.<\/span><\/strong><\/p>\n Let us see this with an example:<\/p>\n RESULT:<\/strong> In previous versions of SQL Server where if we are using ‘+’ to concatenate the values then we know that if one of the values is NULL then concatenated value will be NULL. To avoid this we were needed to use ISNULL function to check if the value is null then consider it as empty string. To achieve the result as in the above SQL 2012 \u00a0example we were needed to write a Sql Statement like below with ISNULL function:<\/p>\n QUIZ:<\/strong><\/span> This is one of the new string functions introduced in SQL Server 2012. This function provides an easy way for the developers to concatenate the string values. Let us first see the syntax of this method: Syntax: CONCAT( string1, string2 [,stringN]) Here the parameters: string1, string2, … ,stringN are the string values which will be … Continue reading CONCAT() STRING FUNCTION IN SQL Server 2012<\/span> SELECT CONCAT('Basavaraj',' ','Biradar') Name<\/pre>\n
\nName
\n—————–
\nBasavaraj Biradar<\/p>\n
\n1) All arguments are implicitly converted to string types before concatenating them.<\/span><\/strong><\/p>\nDECLARE @EmployeeId INT = 1\r\nSELECT CONCAT(@EmployeeId,' ','Basavaraj') EmployeeIDAndName<\/pre>\n
\nEmployeeIDAndName
\n———————-
\n1 Basavaraj<\/p>\nDECLARE @EmployeeId INT = 1\r\nSELECT CAST(@EmployeeId AS VARCHAR) + ' ' \r\n + 'Basavaraj' EmployeeIDAndName\r\n<\/pre>\n
\r\nDECLARE @FirstName VARCHAR(20) = 'Basavaraj', \r\n @LastName VARCHAR(20)\r\nSELECT CONCAT(@FirstName, ' ',@LastName) Name<\/pre>\n
\nName
\n—————————————–
\nBasavaraj<\/p>\n\r\nDECLARE @FirstName VARCHAR(20) = 'Basavaraj', \r\n @LastName VARCHAR(20)\r\nSELECT ISNULL(@FirstName,'') + ' ' \r\n + ISNULL(@LastName,'') Name<\/pre>\n
\nWhether the below query will return all the 8000 characters ‘B’ and 8000 characters ‘C’ in the result?<\/p>\nDECLARE @string1 AS VARCHAR(8000) = REPLICATE('B',8000),\r\n @string2 AS VARCHAR(8000) = REPLICATE('C',8000)\r\nSELECT CONCAT(@string1,@string2)<\/pre>\n","protected":false},"excerpt":{"rendered":"