SQL Server 以逗号分隔 [英] SQL Server split by comma

问题描述

我有一个关于在 T-SQL 中拆分列值的问题.我有

I have a question about splitting column values in T-SQL. I have

Address_col

Nevada,USA
Tokyo,Japan
Hanoi,Vietnam

我想用逗号将值拆分为

Address_col     Country

Navada          USA
Tokyo           Japan
Hanoi           Vietnam

我该怎么做?

推荐答案

declare @T table (Address_col varchar(20))

insert into @T values
('Nevada,USA'),
('Tokyo,Japan'),
('Hanoi,Vietnam')

select left(Address_col, charindex(',', Address_col)-1) as Address_col,
       stuff(Address_col, 1, charindex(',', Address_col), '') as Country
from @T

更新:
将一个字符串拆分为三部分可以如下所示:声明@T 表(Address_col varchar(20))

Update:
Split a string with three parts can look like this: declare @T table (Address_col varchar(20))

insert into @T values
('Nevada,USA,World'),
('Tokyo,Japan,World'),
('Hanoi,Vietnam,World')

select parsename(C, 3),
       parsename(C, 2),
       parsename(C, 1) 
from @T
  cross apply (select replace(Address_col, ',', '.')) as T(C)

这篇关于SQL Server 以逗号分隔的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！