— 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)
Author Archives: Ram - Page 72
Interesting usage of PARSENAME() in SQL
Posted by Ram
on April 7, 2015
No comments