CREATE TABLE #T(Cname VARCHAR(100),Cvalue varchar(100))
insert into #T select 'A:B:C:D:E:F:G','1:0:1:0:1:0:1'
insert into #T select 'A:B:C:D:E:F:G','1:1:1:0:0:1:1'
insert into #T select 'A:B:C:D:E:F:G','1:0:0:0:1:1:0'
insert into #T select 'A:B:C:D:E:F:G','1:1:1:0:1:0:1'
insert into #T select 'A:B:C:D:E:F:G','1:0:1:0:1:0:0'
insert into #T select 'A:B:C:D:E:F:G','0:0:1:0:1:0:0'
insert into #T select 'A:B:C:D:E:F:G','1:0:1:0:1:0:0'
要求结果:
A B C D E F G
1 0 1 0 1 0 1
1 1 1 0 0 1 1
1 0 0 0 1 1 0
1 1 1 0 1 0 1
1 0 1 0 1 0 0
0 0 1 0 1 0 0
1 0 1 0 1 0 0
insert into #T select 'A:B:C:D:E:F:G','1:0:1:0:1:0:1'
insert into #T select 'A:B:C:D:E:F:G','1:1:1:0:0:1:1'
insert into #T select 'A:B:C:D:E:F:G','1:0:0:0:1:1:0'
insert into #T select 'A:B:C:D:E:F:G','1:1:1:0:1:0:1'
insert into #T select 'A:B:C:D:E:F:G','1:0:1:0:1:0:0'
insert into #T select 'A:B:C:D:E:F:G','0:0:1:0:1:0:0'
insert into #T select 'A:B:C:D:E:F:G','1:0:1:0:1:0:0'
要求结果:
A B C D E F G
1 0 1 0 1 0 1
1 1 1 0 0 1 1
1 0 0 0 1 1 0
1 1 1 0 1 0 1
1 0 1 0 1 0 0
0 0 1 0 1 0 0
1 0 1 0 1 0 0
解决方案 »
- 那位高手大哥给点winform小程序例子和web网页例子
- json 异步请求多表问题。
- 实现类似Gmail,163邮箱的多文件上传,谁有比较好的办法
- 方法的类型签名与 PInvoke 不兼容
- 我出100分,关于asp.net打包问题,第一次发帖,帮帮忙吧,谢谢。
- 页面跳转问题?
- 公司的項目,沒搞出來,求大家幫忙
- 请问在ws.net2003下做的项目能在2002下打开吗??
- DataGrid的Header之高度设置如何实现,谢谢!!!
- ASP.Net;在Code中设定文本框的宽度
- swicth 和 if...else if...else 哪个效率高
- 求助!!!批量打印水晶报表(获取打印机问题)~~急急急~~~~~
显示结果:分拆为A-G列
A B C D E F G
---------------
1 0 1 0 1 0 1
1 1 1 0 0 1 1
1 0 0 0 1 1 0
1 1 1 0 1 0 1
1 0 1 0 1 0 0
0 0 1 0 1 0 0
1 0 1 0 1 0 0不明白你的Spler
//通过函数
alter FUNCTION [dbo].[f_splitS](
@s varchar(8000), --待分拆的字符串
@split varchar(10) --数据分隔符
)returns varchar(100)
AS
BEGIN
DECLARE @res varchar(100)
DECLARE @splitlen int
set @res=''
SET @splitlen=LEN(@split+'a')-2
WHILE CHARINDEX(@split,@s)>0
BEGIN
set @res+=' '+LEFT(@s,CHARINDEX(@split,@s)-1)
SET @s=STUFF(@s,1,CHARINDEX(@split,@s)+@splitlen,'')
END
return @res
END
select dbo.f_splitS('A:B:C:D:E:F:G',':')
union select dbo.f_splitS('1:0:1:0:1:0:1',':')
。楼主是一定要拆成列吗?如果只是要这种形式,这个方法可以
cast(parseName(replace(Cname ,':','.'),3) as varchar(10)) Cname1,
cast(parseName(replace(Cname ,':','.'),2) as varchar(10)) Cname2
from
#T
charindex分割字符串