sql布尔类型字段数据写反了如何调换

 bit类型字段0,1如果写反可以试下:

 update table1 set column1-1

 再select column1 from table1 看数据吧,成功对换;

 友情提示:update之前记得先 select column1 into #table2 from table1坐下数据备份;

 

                                                                                

                                                                     

                                                             

 

posted @ 2015-04-02 15:25  东江水  阅读(302)  评论(0编辑  收藏  举报