34,591
社区成员
发帖
与我相关
我的任务
分享
String sql2="UPDATE t_jsxx SET js_jk ='1' where js_xm='"+xm[i]+"' go UPDATE t_jsxx SET js_jk ='0' where js_xm <> '"+xm[i]+"' " ;
update t_jsxx set js_jk=temp.js_jk from
(select case id when 2 then 'bb' when 3 then 'cc' end js_jk from t_jsxx) temp
String sql2="UPDATE t_jsxx SET js_jk =case when js_xm='"+xm[i]+"'" + " then '1' else '0' end";
String sql2="UPDATE t_jsxx SET js_jk ='1' where js_xm='"+xm[i]+"'" go UPDATE t_jsxx SET js_jk ='0' where js_xm <> '"+xm[i]+"' ;