excel 对单元格自动分行
摘要:excel: Variant;WBk, WS, RG: OleVariant;tryExcel := GetActiveOleObject('Excel.Application');exceptExcel := CreateOleObject('Excel.Application');end;wbk
阅读全文
posted @
2020-04-28 08:30
liguang178
阅读(456)
推荐(0)
查询触发器对应的表名
摘要:select triggers.name as [触发器],tables.name as [表名],triggers.is_disabled as [是否禁用],triggers.is_instead_of_trigger AS [触发器类专型],case when triggers.is_inst
阅读全文
posted @
2020-04-08 16:19
liguang178
阅读(942)
推荐(0)
delphi json文件解析
摘要:引用 JsonGYFunctions.pas JSONObject :=TJsonObject.Parse(Memo1.Text) as TJsonObject; //result是json中的一个数组 for j := 0 to JSONObject.A['result'].Count-1 do
阅读全文
posted @
2020-04-08 10:52
liguang178
阅读(2847)
推荐(0)
SQL Server GROUP BY 后 拼接 字符串
摘要:原文地址:https://www.cnblogs.com/guxingy/p/10112135.html原文地址:https://blog.csdn.net/u010673842/article/details/79637618select ID, STUFF((select ',' + name
阅读全文
posted @
2020-04-08 10:47
liguang178
阅读(2728)
推荐(0)