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