以前系统上用过的几条SQL语句

x77899
update PE_Card set Validnum=10 ValidUnit=1 where Cardnum between 02000001 and 02200000

update PE_Card set ValidNum=10 where CardNum between ‘02000001’ and ‘02200000’
update PE_Card set ValidUnit=1 where CardNum between ‘02000001’ and ‘02200000’

UPDATE PE_Card SET
Validnum=’10’
WHERE Cardnum<02200000 and Cardnum>02000001

© 版权声明
THE END
喜欢就支持以下吧
点赞0
分享