--> 数据库版本: --> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 --> 测试数据:[TB] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]') AND type in (N'U')) DROP TABLE [TB] GO---->建表 create table [TB]([KHJKJH] varchar(35)) insert [TB] select 'http://192.168.0.55:8008/xt_record/' GO--> 查询结果 SELECT *, STUFF([KHJKJH],1,CHARINDEX(':8008',[KHJKJH])+4,'') FROM [TB] --> 删除表格 --DROP TABLE [TB]
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO---->建表
create table [TB]([KHJKJH] varchar(35))
insert [TB]
select 'http://192.168.0.55:8008/xt_record/'
GO--> 查询结果
SELECT *,
STUFF([KHJKJH],1,CHARINDEX(':8008',[KHJKJH])+4,'')
FROM [TB]
--> 删除表格
--DROP TABLE [TB]
SUBSTRING(reverse('http://192.168.0.55:8008/xt_record/'),0,
charindex('/',SUBSTRING(reverse('http://192.168.0.55:8008/xt_record/'),2,LEN('http://192.168.0.55:8008/xt_record/')))+2))
declare @url varchar(40)
set @url='http://192.168.0.55:8008/xt_record/'
select substring(@url,patindex('%[0-9A-Z]/%',@url)+1,len(@url))
SELECT RIGHT(@STR,LEN(@STR)-PATINDEX('%8008/%/%',@STR)-3)
/*
/XT_RECORD/(1 行受影响)
*/有具体的规则吗?
set @url='http://192.168.0.55:8008/xt_record/'
select substring(@url,CHARINDEX('/XT',@url),len(@url))
SET @STR = 'http://192.168.0.55:8008/xt_record/'
SELECT RIGHT(@STR, CHARINDEX('/', REVERSE(@STR), 2))