问题描述
- 数据库查询问题，求大神帮忙解决
-
解决方案
用的vs2005，这怎么解决呢，求大神帮忙
关于windows 2008 server R2 文件共享问题，求大神帮忙解决一下！
求大神帮忙关于Openssl实现TLS通信的问题
解决方案二：
declare @tb table
(
BQMC varchar(50),
NR varchar(10)
)
insert into @tb values('cpts', 'lalala')
insert into @tb values('cpts', 'huahuahua')
insert into @tb values('fwnr', '123456')
insert into @tb values('fwnr', '789')
select BQMC, ep_name = (stuff((select ',' + NR from @tb where BQMC =
a.BQMC for xml path('')),1,1,'')) from @tb a group by BQMC
解决方案三：
declare @tb table
(
BQMC varchar(50),
NR varchar(10)
)
insert into @tb values('cpts', 'lalala')
insert into @tb values('cpts', 'huahuahua')
insert into @tb values('fwnr', '123456')
insert into @tb values('fwnr', '789')
select BQMC, ep_name = (stuff((select ',' + NR from @tb where BQMC =
a.BQMC for xml path('')),1,1,'')) from @tb a group by BQMC
解决方案四：
ORACLE数据库写法SELECT BQMC || '|' || replace(WMSYS.WM_CONCAT(NR),',',';' ) AS AA FROM TABLE_t1 GROUP BY BQMC
时间： 2024-04-20 01:51:40