12345678910111213141516171819202122232425262728293031 |
- --¸üÐÂÌÞ³ý±êʶ
- update sqmdb_cost.hetong_new set is_tc='ÊÇ' from sqmdb_cost.hetong_white
- where sqmdb_cost.hetong_new.sid=sqmdb_cost.hetong_white.hetong_sid
- --update sqmdb_cost.hetong_new set is_tc='·ñ'
- --update sqmdb_cost.station_hetong set idx_date='20220805'
- select
- sid,
- sname,
- bdate,
- edate,
- cost,
- cname,
- dname,
- cfname,
- cbzx,
- ename,
- signdate,
- status,
- stype,
- taker_code,
- taker_name,
- taker_mobile,
- nmonth,
- yuezujin
- from sqmdb_cost.hetong_new hn
- where is_tc='·ñ'
|