Geo IP

Re-purposing SQL Server PARSENAME For Splitting IPv4 Addresses

Geo IP
Geo IP

I stumbled across a very nice repurposing of the PARSENAME function in SQL Server recently while playing around with some GeoIP Data. In SQL Server, the PARSENAME function is used for working with fully qualified server objects. e.g. a table on a linked server (‘LinkedServerName . Databasename . Ownername . TableName’). But PARSENAME can be used to easily split up any 4 token, dot delimited string into its constituent parts.

Read More “Re-purposing SQL Server PARSENAME For Splitting IPv4 Addresses”