--> 测试数据:@tb declare @tb table([col] varchar(12)) insert @tb select '10.11.23.21' union all select '10.11.56.87' union all select '10.346.78.90' union all select '20.11.337.55'select parsename(col,4)+'.'+parsename(col,3) from @tb group by parsename(col,4)+'.'+parsename(col,3)/* ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 10.11 10.346 20.11(3 行受影响)*/
--> 测试数据:@tb declare @tb table([col] varchar(12)) insert @tb select '10.11.23.21' union all select '10.11.56.87' union all select '10.346.78.90' union all select '20.11.337.55'select distinct LEFT(col,charindex('.',col,charindex('.',col)+1)-1) as col from @tb/* col ------------ 10.11 10.346 20.11(3 行受影响) */
declare @tb table([col] varchar(12))
insert @tb
select '10.11.23.21' union all
select '10.11.56.87' union all
select '10.346.78.90' union all
select '20.11.337.55'select parsename(col,4)+'.'+parsename(col,3) from @tb group by parsename(col,4)+'.'+parsename(col,3)/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10.11
10.346
20.11(3 行受影响)*/
declare @tb table([col] varchar(12))
insert @tb
select '10.11.23.21' union all
select '10.11.56.87' union all
select '10.346.78.90' union all
select '20.11.337.55'select distinct LEFT(col,charindex('.',col,charindex('.',col)+1)-1) as col from @tb/*
col
------------
10.11
10.346
20.11(3 行受影响)
*/
1 = 对象名称2 = 架构名称3 = 数据库名称4 = 服务器名称
????