What is concat in sql

The following query will try to concatenate 4 different data typed expressions. As we can see, all expressions with different data types are concatenated without any error. Now, we will analyze the execution plan of the query:. When we hover the cursor on the SELECT operator icon, a pop-up window appears and the implicit conversion issue is showing obviously.

Implicit conversion is a data conversion operation that is made by SQL Server automatic when it required. In addition, you can look at the Implicit conversion in SQL Server article to learn more details about the implicit conversion notion.

Now, we will make an example of it:. In addition, if we pass all parameters as NULL , the result of the function will be an empty string. Now, we will make an example of this:. For example, the following query results in the concatenated string line by line with CHAR 13 function:.

This usage type could be a good option when we want to generate a line break. Now, we will make a demonstration of it:.

Author Recent Posts. For older linked servers, the CONCAT operation will happen locally, after the linked server returns the non-concatenated values. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode.

Operating System. Computer Network. Compiler Design. Computer Organization. Discrete Mathematics. Ethical Hacking. Computer Graphics. Software Engineering. Web Technology. Cyber Security. C Programming. Control System.