DECLARE @src NVARCHAR(100)='http://127.0.0.1/uploads/screenshot/1106/screenshot_13.jpg'
SELECT REVERSE(@src)
SELECT CHARINDEX('.',REVERSE(@src))
SELECT CHARINDEX('/',REVERSE(@src))
SELECT SUBSTRING(REVERSE(@src),CHARINDEX('.',REVERSE(@src)) + 1,CHARINDEX('/',REVERSE(@src))-1-CHARINDEX('.',REVERSE(@src)))
SELECT REVERSE(SUBSTRING(REVERSE(@src),CHARINDEX('.',REVERSE(@src)) + 1,CHARINDEX('/',REVERSE(@src))-1-CHARINDEX('.',REVERSE(@src))))