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:22 am

    #1657078

    Depending on the interviewer's definition of "query" it could be

    BEGIN TRAN

    UPDATE ADDRESS SET CITY = 'B'

    ROLLBACK TRAN