//查询以井结束的记录
SELECT f_wellnumber, SUBSTRING(f_wellnumber, 1, LEN(f_wellnumber) - 1)
AS Expr1
FROM CY_wellrecord
WHERE (f_wellnumber LIKE '%井')
//替换井字
UPDATE CY_wellrecord
SET f_wellnumber = SUBSTRING(f_wellnumber, 1, LEN(f_wellnumber) - 1)
WHERE (f_wellnumber LIKE '%井')
//查询中间带空格的记录
SELECT f_wellnumber, REPLACE(f_wellnumber, ' ', '') AS Expr1
FROM CY_wellrecord
WHERE (f_wellnumber LIKE '% %')
//替换中间的空格
UPDATE cy_wellrecord
SET f_wellnumber = REPLACE(f_wellnumber, ' ', '')
FROM CY_wellrecord
WHERE (f_wellnumber LIKE '% %')
//更新id
UPDATE a
SET a.f_wellid = b.f_id
FROM cy_wellrecord a, cy_well b
WHERE a.f_wellnumber = b.f_name
扫码关注腾讯云开发者
领取腾讯云代金券
Copyright © 2013 - 2025 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号:粤B2-20090059 深公网安备号 44030502008569
腾讯云计算(北京)有限责任公司 京ICP证150476号 | 京ICP备11018762号 | 京公网安备号11010802020287
Copyright © 2013 - 2025 Tencent Cloud.
All Rights Reserved. 腾讯云 版权所有