select * from code where ccode like ‘6601%’ –查询所有销售费用的明细
select * from code where ccode=660112 and i_id=1762
update code set bproperty=1 where ccode=660112 and i_id=1762
update code set bproperty=1 where ccode=660113 and i_id=1763
update code set bproperty=1 where ccode=660114 and i_id=1764
update code set bproperty=1 where ccode=660115 and i_id=1765
update code set bproperty=1 where ccode=660116 and i_id=1766
update code set bproperty=1 where ccode=660117 and i_id=1767
update code set bproperty=1 where ccode=660118 and i_id=1768
update code set bproperty=1 where ccode=660119 and i_id=1769
update code set bproperty=1 where ccode=660120 and i_id=1770
update code set bproperty=1 where ccode=660121 and i_id=1771
update code set bproperty=1 where ccode=660122 and i_id=1772
update code set bproperty=1 where ccode=660123 and i_id=1773
update code set bproperty=1 where ccode=660124 and i_id=1774
update code set bproperty=1 where ccode=660125 and i_id=1775
update code set bproperty=1 where ccode=660126 and i_id=1776