摘要:
DECLARE @TEMP NVARCHAR(50)SET @TEMP='WONDER\CCCP\KOUMI\TEST.TIF'select @temp--SELECT charindex('\',@TEMP)SELECT REVERSE(@TEMP)SELECT CHARINDEX('\', REVERSE(@TEMP))SELECT SUBSTRING(REVERSE(@TEMP),0,CHARINDEX('\', REVERSE(@TEMP)))SELECT REVERSE(SUBSTRING(REVERSE(@TEMP) 阅读全文