CrazyJS,疯狂的JS

将查询结果的某列按指定的符号连接起来 SQL函数 返回字符串

–将查询结果的某列按指定的符号连接起来 –AUTHOR:Mender.Z.J ALTER procedure dbo.getColWithMerg (  @preSymbol   varchar(256),  @tailSymbol   varchar(256),  @colName   varchar(50),  @queryStr   varchar(1024),  @retStr  varchar(8000) output )   as BEGIN  declare @count as decimal; declare @sqlStr as varchar(1000); declare @i as decimal; –declare @retStr as varchar(8000); declare @tt as varchar(255); set @i=1; set @sqlStr=’select ‘+ @colName +’ from (‘+@queryStr+’) as t1′ ; &n [...]