I have a table like
so i want to update city column from A to B and again B to A by in single statement..please help.
So, update it twice, use single statement. No problem!
set City =
when City = A then B
when City = B then A
According to BOL "GO is not a Transact-SQL statement; it is a command" ;-)