sql server 2016中截取TB_SVN_Path_Cache表中fpath列中第三个‘/’和第四个‘/’之间的字段
时间: 2023-03-14 20:18:13 浏览: 96
sql Server 表中字段二进制截取查找
SELECT SUBSTRING(fpath,CHARINDEX('/',fpath, CHARINDEX('/',fpath,1)+1)+1, CHARINDEX('/',fpath,CHARINDEX('/',fpath, CHARINDEX('/',fpath,1)+1)+1)-CHARINDEX('/',fpath,CHARINDEX('/',fpath,1)+1)-1) FROM TB_SVN_Path_Cache
阅读全文