1、string[] ids = extData.Split(new char[] { ';' });
2、extData.Replace(";", "','");
string.Format(strSQL, extData.Replace(";", "','"))
3、1
select (select '''' + replace('8ae89512-4e5a-e811-93f3-00155d80206d;
89e89512-4e5a-e811-93f3-00155d80206d;88e89512-4e5a-e811-93f3-00155d80206d',';',''',''')+ ''''),a.*
from ReturnBid a Left JOIN ResultSP b on a.ReturnBidGUID = b.ReturnBidGUIDwhere a.ReturnBidGUID IN ('8ae89512-4e5a-e811-93f3-00155d80206d','89e89512-4e5a-e811-93f3-00155d80206d','88e89512-4e5a-e811-93f3-00155d80206d')
and a.WinBidResult='已中标' and b.AuditStatus ='已审核';
3、2
select replace('''8ae89512-4e5a-e811-93f3-00155d80206d;89e89512-4e5a-e811-93f3-00155d80206d;88e89512-4e5a-e811-93f3-00155d80206d''',';',''',''')
from cg_CgProcReturnBid a Left JOIN cg_CgProcResultSP b on a.CgProcReturnBidGUID = b.CgProcReturnBidGUID
两个SQL 结果为下图:但是用在in中会报错
错误图,暂时记录