SQL segmentation and grouping for multiple IDs or names

In the development often encountered to put multiple IDs together with a symbol to separate the incoming database, that split is a big deal

SELECTNpushid into#Temp     fromTable1WHERE  CHARINDEX(',' + CONVERT(VARCHAR(Ten), NCOULMN)+ ',',',' + '3305,3311,3314' + ',')> 0SELECT *  from#Temp

The columns here are for the int type, so you want to convert.

For orders that order the master-slave table, from the table multiple names are stitched together

--Instance 1 separator in frontSelect IsNull((Select '@'+Commodityname fromOrderInfowhereOrderinfo.orderid=Ordermain.orderid forXML Path ("')),"') fromOrdermainwhereOrderID='20120302121548'--for the separator before, can be used stuff very convenientSelect IsNull(Stuff((Select '@'+Commodityname fromOrderInfowhereOrderinfo.orderid=Ordermain.orderid forXML Path ("')),1,1,"'),"') fromOrdermainwhereOrderID='20120302121548'--Example 2 with table, delimiter in postSELECT  distinctVcname,dtcreatetime,ISNULL((Select CONVERT(VARCHAR(5), NCode)+','  fromTable1 AwhereA.vcname=B.vcname andA.dtcreatetime=B.dtcreatetime forXML Path ("')),"') asVccode fromTable1 b--after the delimiter, for the name of the stitching, the personal feel with substring, left also trouble point, as in the background or the front desk to deal with

SQL segmentation and grouping for multiple IDs or names