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

  • September 25, 2013 at 10:29 pm

    #1653404

    hi,

    here i am not able to trust it is updated with 'A'

    supose in cte last select statement can be changed to 'AA' it is not showing last updated record that is 'AA'

    Thanks,

    Dastagiri