sql server 2016中截取TB_SVN_Path_Cache表中fpath列中两个‘/’之间的字段
时间: 2023-03-14 20:03:59 浏览: 77
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
sql server 2016中截取TB_SVN_Path_Cache表中fpath列中第三个‘/’和第四个‘/’之间的字段
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
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)