使用sql语句(ip地址)拆分字符串 [英] Splitting string using sql statement (ip address)

问题描述

我需要在sql中拆分ip地址.

I need to split ip address in sql.

我做了很多查找，但找不到任何可以完成任务的内置方法.

I have done lots of finding but could not find any builtin method that do the task.

我怎样才能完成这个任务?

How can I accomplish this task?

我使用的是sql server

I am using sql server

推荐答案

您可以使用 PARSENAME 函数如下:

You can use PARSENAME function as following :

with address as(
select '192.168.1.1' as IpAddress
Union
select '192.168.1.2' as IpAddress
Union
select '192.168.1.3' as IpAddress
)
SELECT PARSENAME(IpAddress,4) as first, 
   PARSENAME(IpAddress,3) as second,
   PARSENAME(IpAddress,2) as third,
   PARSENAME(IpAddress,1) as fourth,
FROM address

PARSENAME 函数返回对象名称的指定部分.

PARSENAME function returns the specified part of an object name.

这篇关于使用sql语句(ip地址)拆分字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！