随笔 - 32  文章 - 0 评论 - 3 trackbacks - 0

摘要:select * from T_A a (nolock) where a.xh not in (select xh from T_B) 方法1:效果甚微 select * from T_A a (nolock) where not exists (select xh from T_B where x 阅读全文
posted @ 2020-07-18 16:17 风与夕阳 阅读(170) 评论(0) 推荐(1) 编辑
摘要:--列转行小实例 --创建测试表 if object_id(N'test', N'U') is not null drop table test go with UnPivotTable as ( select 1 as UserNO, '33' as A, '44' AS B, '55' as C 阅读全文
posted @ 2020-05-17 22:07 风与夕阳 阅读(102) 评论(0) 推荐(0) 编辑
摘要:with t as ( select '-' as col1 --isnumeric('-')这里会判断为数字,所以不能用 union all select '1' as col1 union all select '2' as col1 union all select '3.4' as col1 阅读全文
posted @ 2020-04-14 22:00 风与夕阳 阅读(93) 评论(0) 推荐(0) 编辑
摘要:--行转列小实例 --创建测试表 if object_id(N'test', N'U') is not null drop table test go with PivotTable as ( select 'xxx' as czy, '点赞' as czlx, 2 as num union all 阅读全文
posted @ 2020-04-14 21:50 风与夕阳 阅读(111) 评论(0) 推荐(0) 编辑
摘要:界面代码: object Form1: TForm1 Left = 252 Top = 190 Width = 1149 Height = 549 Caption = 'Form1' Color = clBtnFace Font.Charset = GB2312_CHARSET Font.Color 阅读全文
posted @ 2020-03-08 17:25 风与夕阳 阅读(96) 评论(0) 推荐(2) 编辑
摘要:首先提供两个XML文件 XML代码如下: 1、Example.xml <?xml version="1.0" encoding="ISO-8859-1"?> <chart> <series title="Series1" type="Point" color="#FF0000"> <points c 阅读全文
posted @ 2020-03-03 21:35 风与夕阳 阅读(86) 评论(0) 推荐(1) 编辑
摘要:界面代码: object Form1: TForm1 Left = 568 Top = 393 Width = 725 Height = 408 Caption = '对象观察器' Color = clBtnFace Font.Charset = DEFAULT_CHARSET Font.Color 阅读全文
posted @ 2020-02-29 12:55 风与夕阳 阅读(80) 评论(0) 推荐(1) 编辑
摘要:界面代码: object Form1: TForm1 Left = 202 Top = 182 Width = 1305 Height = 675 Caption = 'Form1' Color = clBtnFace Font.Charset = DEFAULT_CHARSET Font.Colo 阅读全文
posted @ 2020-02-26 21:56 风与夕阳 阅读(117) 评论(0) 推荐(1) 编辑
摘要:先上图 功能代码: unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, TeEngine, Series, TeeNavigato 阅读全文
posted @ 2020-02-21 19:34 风与夕阳 阅读(107) 评论(0) 推荐(1) 编辑
摘要:最近不知怎么的,想研究一下图表。先上效果图: 功能代码: unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, TeeEdit, E 阅读全文
posted @ 2020-02-20 19:47 风与夕阳 阅读(85) 评论(0) 推荐(1) 编辑