Tomaž Kaštrun 12/23/2025

Advent of 2025, Day 23 – SQL Server 2025 – T-SQL Features – String concatenation with || and compound assignment ||=

Read Original

This technical article details two new string operators in Microsoft SQL Server 2025: the ANSI SQL standard || operator for string concatenation and the ||= compound assignment operator. It explains their syntax, demonstrates usage with code examples, and discusses behavior with NULL values and different data types.

Advent of 2025, Day 23 – SQL Server 2025 – T-SQL Features – String concatenation with || and compound assignment ||=

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert 2 votes
3
LLM Use in the Python Source Code
Miguel Grinberg 1 votes
4
Wagon’s algorithm in Python
John D. Cook 1 votes