String concatenation operator ||

SQLServerCentral Article

T-SQL in SQL Server 2025: Concatenating Strings

  • Article

Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +.  We have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This is the double pipe (||) operator. This article looks at […]

(4)

You rated this post out of 5. Change rating

2025-11-14

3,501 reads

Blogs

Breaking Rules in Rome

By

Last week I was honored with a trip to Rome for the Redgate President’s...

Databases and AI Agents

By

As part of my wider work exploring Claude Code and AI-assisted database engineering, I...

Creating a Pulsing Conducting Baton - Part 1

By

Train Wreck The last time I watched a high school band nearly fall apart mid-performance...

Read the latest Blogs

Forums

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

By Sanket Parmar

Comments posted to this topic are about the item Why Your Index Isn't Being...

Distance Metric Algorithms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distance Metric Algorithms

What Can AI Really Do?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What Can AI Really Do?

Visit the forum

Question of the Day

Distance Metric Algorithms

What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?

See possible answers