SQLserver 的内置函数PARSENAME使用指定的分隔符，无效返回null

Question

 

select  top 100 PARSENAME(REPLACE(image_path,'&&','.'),1) as A
					from ttraffic_vehicle_pass order by pass_time desc

该字段的数据格式

/VehiclePic/370881001/01/20200925/20200925092410703_H6317S_CarPic1.jpg&/VehiclePic/370881001/01/20200925/20200925092410703_H6317S_CarPic2.jpg&&/VehiclePic/370881001/01/20200925/20200925092410703_H6317S_CarPic4.jpg

返回为null,用默认的"."可以分割

Answer 1

参考这个代码测试一下：

1、完整引用的对象名称时
DECLARE @sobjName sysname
set @sobjName='MSSQLSERVER2008.test.dbo.student'
select PARSENAME(@sobjName,1) as ObjectName,PARSENAME(@sobjName,2) as OwnerName,
 PARSENAME(@sobjName,3) as DatabaseName,PARSENAME(@sobjName,4) as ServerName

测试结果：
ObjectName   OwnerName DatabaseName   ServerName
-----------  --------  -------------  -----------------------
student      dbo test        MSSQLSERVER2008

2、不完整引用的对象名称时
DECLARE @sobjName sysname
set @sobjName='MSSQLSERVER2008...student'
select PARSENAME(@sobjName,1) as ObjectName,PARSENAME(@sobjName,2) as OwnerName,
 PARSENAME(@sobjName,3) as DatabaseName,PARSENAME(@sobjName,4) as ServerName

测试结果：
ObjectName   OwnerName DatabaseName   ServerName
-----------  --------  -------------  -----------------------
student      null null        MSSQLSERVER2008