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
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
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
insert into tb values('61.1.10.5')
insert into tb values('61.151.1.35')
insert into tb values('61.12.104.135')
goselect 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 tbdrop table tb/*
logip
---------------
061.001.010.005
061.151.001.035
061.012.104.135(所影响的行数为 3 行)
*/
right('000'+PARSENAME(logip , 4) ,3) + '.' + --3改为2
right('000'+PARSENAME(logip , 3) ,3) + '.' +
right('000'+PARSENAME(logip , 2) ,3) + '.' +
right('000'+PARSENAME(logip , 1) ,3)
from 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')
insert into tb values('161.12.104.135')
insert into tb values('1.12.104.135') goselect 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