update Table_1 set CameraID=substring(CameraID,charindex(‘=’,CameraID)+1,len(CameraID)-charindex(‘=’,CameraID)),
CameraLocation=SUBSTRING(CameraID,0,CharIndex(‘=’,CameraID))
sql 根据字符截取字符串
最新推荐文章于 2024-06-12 19:20:06 发布
update Table_1 set CameraID=substring(CameraID,charindex(‘=’,CameraID)+1,len(CameraID)-charindex(‘=’,CameraID)),
CameraLocation=SUBSTRING(CameraID,0,CharIndex(‘=’,CameraID))