22,209
社区成员
发帖
与我相关
我的任务
分享
create table tb(logip varchar(50))
insert into tb values('61.1.10.5')
insert into tb values('61.151.1.35')
insert into tb values('61.12.104.135')
insert into tb values('161.12.104.135')
insert into tb values('1.12.104.135')
go
select logip =
right('000'+PARSENAME(logip , 4) ,len(PARSENAME(logip , 4))) + '.' +
right('000'+PARSENAME(logip , 3) ,3) + '.' +
right('000'+PARSENAME(logip , 2) ,3) + '.' +
right('000'+PARSENAME(logip , 1) ,3)
from tb
/*
logip
---------------
61.001.010.005
61.151.001.035
61.012.104.135
161.012.104.135
1.012.104.135
*/
drop table tb
create table tb(logip varchar(50))
insert into tb values('61.1.10.5')
insert into tb values('61.151.1.35')
insert into tb values('61.12.104.135')
go
select logip =
right('000'+PARSENAME(logip , 4) ,3) + '.' +
right('000'+PARSENAME(logip , 3) ,3) + '.' +
right('000'+PARSENAME(logip , 2) ,3) + '.' +
right('000'+PARSENAME(logip , 1) ,3)
from tb
drop table tb
/*
logip
---------------
061.001.010.005
061.151.001.035
061.012.104.135
(所影响的行数为 3 行)
*/
select logip =
right('000'+PARSENAME(logip , 4) ,3) + '.'
right('000'+PARSENAME(logip , 3) ,3) + '.'
right('000'+PARSENAME(logip , 2) ,3) + '.'
right('000'+PARSENAME(logip , 1) ,3)
from tb
select logip =
right('000'+PARSENAME(logip , 4) ,3) + '.'
right('000'+PARSENAME(logip , 3) ,3) + '.'
right('000'+PARSENAME(logip , 2) ,3) + '.'
right('000'+PARSENAME(logip , 1) ,3)
from tb