sql server 2016中截取TB_SVN_Path_Cache表中fpath列中第二个和第三个‘/’之间的字段

SELECT SUBSTRING(fpath, CHARINDEX('/', fpath, 1) + 1, CHARINDEX('/', fpath, CHARINDEX('/', fpath, 1) + 1) - CHARINDEX('/', fpath, 1) - 1) FROM TB_SVN_Path_Cache

相关问题

sql server 2016中截取TB_SVN_Path_Cache表中fpath列中两个‘/’之间的字段

SELECT SUBSTRING(fpath, CHARINDEX('/', fpath)+1, CHARINDEX('/', fpath, CHARINDEX('/', fpath)+1)-CHARINDEX('/', fpath)) FROM TB_SVN_Path_Cache

sql server 2016中截取TB_SVN_Path_Cache表中fpath列中第二个‘/’和第三个‘/’之间的字段

SELECT SUBSTRING(fpath, CHARINDEX('/', fpath, 1) + 1, CHARINDEX('/', fpath, CHARINDEX('/', fpath, 1) + 1) - CHARINDEX('/', fpath, 1) - 1) FROM TB_SVN_Path_Cache