摘要:
set statistics io onset statistics time ON --主从表可用 SELECT vcaa, vcbb, ISNULL(( SELECT vcCN + ',' FROM TableB b WHERE a.vcaa= b.vcaa FOR XML PATH('') ) 阅读全文
摘要:
using Newtonsoft.Json; using Newtonsoft.Json.Linq; string jsonText = "[{'a':'aaa','b':'bbb','c':'ccc'},{'a':'aaa2','b':'bbb2','c':'ccc2'}]"; string a = JObject.Parse(JArray.Parse(jso... 阅读全文
摘要:
SELECT snFundType,snBusinessType, CASE WHEN a.snFundType=10 AND a.snBusinessType =10 THEN (select vcPaySerialNo from aa where vcSerialNo=a.vcRelationSerialNo) WHEN a.snFundType=11 AND a.snBusinessTy... 阅读全文