如何在给定的场景中将值更新到表中.... [英] How can Update the values into table in given Scenario....

问题描述

我有自动增量ID的表，在coulumn Name Values的每个字段中有一个Coulum具有备用值0和1，我需要将每个0替换为值1并且每个1替换值0 .....可以任何一个帮我做这个...... !!!!!!!!!!

解决方案

试试这个

 UPDATE Table_Name 
 SET Column_Name = CASE Column_Name WHEN  0  THEN  1  WHEN  1 然后 0 结束

问候..

< blockquote>

 更新 YourTable 
  SET  YourTable.ColWith0or1 = < span class =code-keyword> CASE   WHEN  YourTable.ColWith0or1 =  0   THEN   1   ELSE   0   END  

I have table with Auto increment Id ,With one Coulum having alternate values 0 and 1 in each field in coulumn Name Values,I need to replace each 0 by value 1 And each 1 by value 0 .....Can any one help me to doing it....!!!!!!!!!!

解决方案

Try this

UPDATE Table_Name
SET Column_Name = CASE Column_Name WHEN 0 THEN 1  WHEN 1 THEN 0 END

Regards..

UPDATE YourTable
SET YourTable.ColWith0or1 =  CASE WHEN YourTable.ColWith0or1 = 0 THEN 1 ELSE 0 END

这篇关于如何在给定的场景中将值更新到表中....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！