Converting SQL column data to strings

Row and column conversions, converting columns data to string output

DECLARE @center_JZHW VARCHAR( -)SET @center_JZHW =(SELECT DISTINCT STUFF(    ( SELECT  ',' +Ce_code fromAp_center with(NOLOCK)WHERECe_province= 'Zhejiang province' ORDER  byCe_code forXML PATH ("')),1,1,"') asJZHW fromap_center t)SELECT @center_JZHW

View Code

Run results such as, column ce_code with delimiter ', ' output

function notation

DECLARE @ret VARCHAR( $)        SET @ret = "'        SELECT  @ret = @ret + '|' + RTRIM(Rt_gsx_comptia_code) fromdbo. Ap_request_return_partWHERERt_so_no= @so_no        SET @ret =  Case  when LEN(@ret)> 0  Then STUFF(@ret,1,1,"')                        ELSE @ret                   END        RETURN @ret 

View Code

The execution output is

Multiple columns as field output:

SELECT DISTINCT STUFF(    ( SELECT  ',' +Rt_loan_part fromDbo. Ap_request_return_partWHERERt_so_no='IPTH14060001'       forXML PATH ("')),1,1,"') asPart ,STUFF(    ( SELECT  ',' +Rt_gsx_comptia_code fromDbo. Ap_request_return_partWHERERt_so_no='IPTH14060001'       forXML PATH ("')),1,1,"') asComptia_code fromAp_request_return_part T

View Code

Execution Result: