update query

• pnpsql

  SSC-Addicted

  Points: 456

  More actions

  December 29, 2011 at 8:58 pm

  #262238

  hi all, i have a table with a city column, i need to update the city like where city name is 'A' then it should be 'B' and when city name is

  'B' then it should be 'A'

• sql-programmers

  SSC-Addicted

  Points: 494

  More actions

  December 29, 2011 at 9:53 pm

  #1426769

  Hi,

  Try this code..

  CREATE TABLE #IREMS (ItemID INT, City VARCHAR(20))

  INSERT INTO #IREMS (ItemID , City )

  SELECT 11, 'a' UNION ALL

  SELECT 22, 'b' UNION ALL

  SELECT 33, 'a' UNION ALL

  SELECT 44, 'hh' UNION ALL

  SELECT 55, 'b' UNION ALL

  SELECT 66, 'a'

  SELECT * FROM #IREMS

  UPDATE #IREMS SET City = CASE WHEN City='a' THEN 'b' WHEN City='b' THEN 'a' ELSE City END

  SELECT * FROM #IREMS

  DROP TABLE #IREMS

  SQL Sever Performance tuning