컬럼에 있는 URL에서 파일명만 추출하기

create table test(URL varchar(50))
insert test
select 'http://blog.rss.naver.com/pjh0001.xml' union all
select 'http://blog.rss.naver.com/pjh0002.xml' union all
select 'http://blog.rss.naver.com/pjh0003.xml' union all
select 'http://www.naver.com/image/images/pjh0004.xml'

------------------------------------
select reverse(parsename(left(reverse(URL),charindex('/',reverse(URL),1)-1),1)) URL from test
/*
URL
---------------
pjh0001
pjh0002
pjh0003
pjh0004

출처 : SQLER