Other
Other
ANSI String Concatenation in SQL Server 2025 and Azure SQL Database
SQL Server 2025 and Azure SQL Database bring the ANSI-standard || operator to T-SQL, giving developers a third option next to + and CONCAT(). It converts types implicitly like CONCAT() but propagates NULL like +.