Monthly Archives: April 2015 - Page 18

Interesting usage of PARSENAME() in SQL

— Limitation of only 3 DOTS or 4 max value
select parsename('my.name.is.admin', 4)
select parsename('my.name.is.admin', 3)
select parsename('my.name.is.admin', 2)
select parsename('my.name.is.admin', 1)