字符串合并与拆分写法小结

字符串合并与拆分写法小结 一. 字符合并?1234567891011121314if OBJECT_ID('ConcatStr') is not nulldrop table ConcatStrGOc

字符串合并与拆分写法小结 一.字符合并 ? 1 ifOBJECT_ID('ConcatStr')isnotnull 2 droptableConcatStr 3 GO 4 createtableConcatStr 5 ( 6 IDint, 7 Codevarchar(10) 8 ) 9 GO 10 insertintoConcatStr 11 select1,'XXX'unionall 12 select1,'YYY'unionall 13 select2,'PPP'unionall 14 select2,'QQQ' 要得到这样的结果： ? 1 IDCode 2 1XXX,YYY 3 2PPP,QQQ 1.用游标 ? 1 declare@ttable(IDint,Codevarchar(1000)) 2 declare@idint 3 declareccursorfor 4 selectdistinctIDfromConcatStr 5 openc 6 fetchnextfromcinto@id 7 while@@fetch_status=0 8 begin