Post reply

T-SQL in SQL Server 2025: The || Operator

  • December 19, 2025 at 12:00 am

    #4693566

    Comments posted to this topic are about the item T-SQL in SQL Server 2025: The || Operator

  • December 19, 2025 at 8:25 am

    #4702581

    Worth mentioning: the CONCAT function implicitly converts all arguments to character data types, while the + operator always chooses the cheapest possible type conversion. This often results in errors when mixing strings and numbers.

  • December 19, 2025 at 10:38 am

    #4702641

    Thank you for the sum up of the new "Operator".

    I believe it's beneficial to have this operator available as an ANSI standard in SQL Server. This is especially true when it comes to porting from other database systems to Microsoft SQL Server.

    I'm thinking particularly of Oracle and PostgreSQL, which are significantly closer to ANSI standards than Microsoft SQL Server.

    Microsoft Certified Master: SQL Server 2008
    MVP - Data Platform (2013 - ...)
    my blog: http://www.sqlmaster.de (german only!)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply