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