Home Forums SQL Server 2012 SQL Server 2012 - T-SQL how to update column city value from 'A' to 'B' and 'B' to 'A' in single query RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

  • October 9, 2013 at 5:45 am

    #1657084

    LutzM (10/8/2013)

    If you insist doing it "in single statement", how about this:

    EXEC (...).

    If we'd agree this would qualify as a single statement, we're all set. Right? 😀

    To "support my argument": BOL qualifies EXEC as a statement: ...SQL Server extends the EXECUTE statement...

    In this vein, is a BEGIN .. END block considered a single statement?