随笔 - 31  文章 - 0 评论 - 2 trackbacks - 0

摘要:--列转行小实例 --创建测试表 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 风与夕阳 阅读(84) 评论(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 风与夕阳 阅读(81) 评论(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 风与夕阳 阅读(102) 评论(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 风与夕阳 阅读(84) 评论(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 风与夕阳 阅读(75) 评论(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 风与夕阳 阅读(73) 评论(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 风与夕阳 阅读(103) 评论(0) 推荐(1) 编辑
摘要:先上图 功能代码: unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, TeEngine, Series, TeeNavigato 阅读全文
posted @ 2020-02-21 19:34 风与夕阳 阅读(96) 评论(0) 推荐(1) 编辑
摘要:最近不知怎么的,想研究一下图表。先上效果图: 功能代码: unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, TeeEdit, E 阅读全文
posted @ 2020-02-20 19:47 风与夕阳 阅读(79) 评论(0) 推荐(1) 编辑
摘要:环境:SQL 2016; 语句 select * from A where PID=JoID 上述查询语句中的Where PID=JoID条件中PID的字段类型为varchar(50)而JoID的字段类型为uniqueidentifier,该写法在升级之前的(SQL2012)库上没有问题,但在新库( 阅读全文
posted @ 2020-01-16 10:02 风与夕阳 阅读(160) 评论(0) 推荐(0) 编辑