拆分列为行

最新推荐文章于 2023-06-01 18:00:06 发布

zonelive

最新推荐文章于 2023-06-01 18:00:06 发布

阅读量858

点赞数

文章标签： table

本文链接：https://blog.csdn.net/zonelive/article/details/419451

版权

create table tb3
(id int identity(1,1) primary key clustered,
l_name varchar(100))

--tb3数据
id          l_name
----------- ----------------------------------------------------------------------------------------------------
1           gsdg#123
2           fh#3435
3           fghdfgh#67867
4           lkhgvhg#7688796

SELECt id,left(l_name,charindex('#',l_name)-1) l_name }
from tb3
union all
SELECt id,substring(l_name,charindex('#',l_name)+1,len(l_name)-charindex('#',l_name)+1) l_name
from tb3

--显示结果
id          l_name
----------- ----------------------------------------------------------------------------------------------------
1           gsdg
2           fh
3           fghdfgh
4           lkhgvhg
1           123
2           3435
3           67867
4           7688796