- 博客(2)
- 资源 (133)
- 收藏
- 关注
RSS订阅原创 万能数据库应用系列视频（二） 软件开发高手须掌握的4大SQL精髓语句之内连接和外连接
马根峰微信公众号： 万能数据库查询分析器** 视频详细地介绍了软件开发高手须掌握的4大SQL精髓语句之内连接和外连接，然后使用万能数据库查询分析器的中文版本DB 查询分析器结合MS ACCESS，演示内连接和外连接应用。 https://v.qq.com/x/page/z06473l8wdn.html 万能数据库查询分析器简介： 硕士程序员马根峰（CSDN专访马根峰：海...
2018-05-12 16:14:51
478
原创 万能数据库应用系列视频（一） 使用SQL语句直接高效地访问文本文件
视频详细地介绍了“万能数据库查询分析器”，中文版本 DB 查询分析器 在 文本文件 处理方面非常强大的功能。 你可以直接用SQL语句来访问这些文本文件，访问最大为250万条记录的文件跟其它4个文件进行复杂的关联操作、子查询，也不过用时1分钟左右。需要注意的是，文本文件的第一行需要有列名。具体视频请点击以下链接： 腾讯视频 万能数据库应用系列视频（一） 使用SQL语句直接高效地访问文本文件 万...
2018-05-07 18:35:22
706
DB Query Analyzer specification_Version6.03
From 6.01, DB Query Analyzer provides SQL Execute Schedule function to execute SQL scripts in certain time. Without changing any Windows OS settings or configurations, DB Query Analyzer 6.03 can run on any Microsoft Windows OS directly.
2014-12-17
DB 查询分析器使用手册（最新的6.03版本）
你可以通过“万能数据库查询分析器” ① 查询ODBC数据源（包括世面上所有的数据库、TXT/CSV文件、EXCEL文件）的数据。 ③ 从数据库导出千万条数据时，效率与DBMS没有什么区别；④ 具有强大的 SQL “执行计划”功能； ⑤ 6．03版本已经完全兼容任何Microsoft的Windows操作系统系列，可以直接在Windows操作系统上运行，而不需要更改任何操作系统的设置或者配置。
2014-12-17
万能数据库查询分析器使用技巧（十六）
本文详细地介绍了“万能数据库查询分析器”，中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》6.02 中新增的SQL “执行计划”数据库连接自动恢复功能。“在CSDN专访马根峰”的文章中，编辑问我如果有时间，我会做什么？我说会实现万能数据库查询分析器的“执行计划”数据库连接自动恢复功能。非常高兴这一段时间内终于实现了此功能。
从6.02版本开始，只要将“工具-选项”窗口中的选项“SQL执行计划连接自动恢复”设置为“选中”状态，那么即使在“SQL执行计划”期间数据库服务器宕过机，只要在“SQL执行计划”的时刻数据库服务器是处理启动状态，那么“SQL执行计划”都会被执行。
2014-11-27
万能数据库查询分析器 6.02发布 ，本人为之撰写的相关技术文章达71篇
万能数据库查询分析器 6.02版本实现了：
只要将“工具-选项”窗口中的选项“SQL执行计划连接自动恢复”设置为“选中”状态，那么即使在“SQL执行计划”期间数据库服务器宕过机，只要在“SQL执行计划”的时刻数据库服务器是处理启动状态，那么“SQL执行计划”都会被执行。
2014-11-26
The 16th tip of DB Query Analyzer
Up to Nov 21,2014, the latest version of DB Query Analyzer is 6.02. In 6.02, if you selected the option 'SQL Schedule Reconnect' in window configurations, the Schedule SQL scripts will be executed as long as the Database Server is in use, even though the Database Server had been down.
2014-11-21
Notice to users of DB Query Analyzer in Win7_Win8_Windows2010
Unlike WinXP, VISTA, Windows2000, Windows Nt and Win98, Win7/Win8/Windows 2010 select ‘/’ as the default seperator character between short date. Although the former windows OS chooses ‘-‘ as the default setting.
I am very sorry to inform you, my dear friends, that this will result in an error while running DB Query Analyzer, including English version ‘DB Query Analyzer’ and Simplified Chinese version .
I ensure you that I will solve this BUG in DB Query Analyzer 6.03. In order to use DB Query Analyzer properly, here I will illustrate how to set ‘-‘ as the default setting of short date in Win7.
2014-11-19
使用“万能数据库查询分析器”的Win7、Win8、Windows 2010的用户须知
与以前的Windows操作系统版本（包括WinXP/VISTA/Windows2000/Windows Nt/Win98）不同，Win7、Win8、Windows 2010短日期采用的分隔符默认为“/”，而以前的默认分隔符为“-”。
这会导致“万能数据库查询分析器”的运行过程中，出现问题，故提醒Win8、Windows 2010操作系统用户，将短日期分隔符设置为“-”。
本人会在“万能数据库查询分析器”中文版本《DB 查询分析器》6.03版本、英文版本《DB Query Analyzer》 6.03版本中解决这一问题，不便之处，敬请谅解。
2014-11-19
DB Query Analyzer 6.02 is distributed, 71 articles concerned have been published
DB Query Analyzer 6.02 is distributed, 71 articles concerned have been published
2014-11-17
万能数据库查询分析器使用技巧（十五）
本文详细地介绍了“万能数据库查询分析器”，中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》6.01 中新增的SQL “执行计划”功能。
从6.01版本开始，用户可以对要执行的SQL 脚本建立执行计划，在指定的时间来执行这些SQL 脚本。从而一方面可以有效地避免集中地向系统提交查询请求，另一方面也可以避开系统繁忙的时候来执行自己的SQL语句。
2014-10-11
How to download the installation package by ZOL Downer
Recently, Zhongguancun Online distributed the ZOL Downer for users to download the resources from ZOL. In this case, users can just download the ZOL downer with the code of resources, not the installation packages.
But if someone want to install the PC which is isolated from the INTERNET, he or she will no longer do that.
So how do the users download the installation packages? In this essay I will give you a sample to download the installation packages of DB Query Analyzer.
2014-08-22
DB Query Analyzer 5.05 is distributed, 65 articles concerned have been published
DB QueryAnalyzer is one of the few excellent Client Tools in the world for its’powerful function, friendly interface, easy operation and applicability toevery production of RDBMS.
It lets you query ODBC data sources, author SQL scripts and queries,return query results to a grid or free-form text or a file, retrieve ODBCdriver information, execute multiple SQL scripts or stored proceduressimultaneously, and more.
2014-07-22
Access text files using SQL statements by DB Query Analyzer
Is it a dream that you can access text files using SQL statements？
But now, it is true that DB Query Analyzer provides you a power tool which can help you realize the dream above. I’ll give you a sample to show its powerful function. What’s more, the process is so efficient that you can get result by querying files with 2,500,000 records in about 59 seconds.
2014-06-20
基于数据仓库的广东省高速公路一张网过渡期通行数据及异常分析系统
星形模式是基于关系数据库的数据仓库中的一个著名概念，由于星形连接模式的设计思想能够满足人们从不同观察角度（维）分析数据的需求，所以在基于关系数据库的数据仓库的设计中广泛地使用了星形模式。本文主要介绍《广东省高速公路一张网资金结算情况分析系统》中的数据仓库技术。
2014-05-23
The 14th tip of DB Query Analyzer
In this essay I will demonstrate how to display the content of a certain function in DB2 by DB Query Analyzer.
2014-02-10
软件开发顶尖高手的杀手锏SQL语句
在SQL（Structured Query Language）语言DML中，有四大语句堪称其精髓部分。本人分别在“软件开发高手须掌握的4大SQL精髓语句（一）”至“软件开发高手须掌握的4大SQL精髓语句（四）” 4篇文章中进行了详细的阐述。而在“软件开发高手须掌握的4大SQL精髓语句（综合篇）”文章中，则用以上4大SQL精髓语句结合起来解决一个非常复杂的实际问题，最终在CSDN博客上获得了不同寻常的11000 多次访问量。
其实，还有一条SQL语句堪称软件开发顶尖高手的杀手锏。不客气地说，大部分软件开发人员估计一辈子也不会有机会在工作中遇到这样的机会来使用它。这就是“全外连接”(Full Outer Join)。本文通过工作中的一个实例，以“万能数据库查询分析器”的中文版本《DB 查询分析器》为工具，来访问自己创建的数据库中的相关表，来展示整个问题的解决过程。
2014-01-23
Which SQL statement is the trump card to the senior software developer
Within so many kinds of DML statements in SQL, I think four kinds of them, including Case When, Left Outer Join/Left Join / Right Outer Join /Right Join/ Inner Join, WITH AS and UNION/UNION ALL, are essential for the Database Developer.
In fact, there is a kind of SQL statement which might be the trump card to the senior software developer. I can say, immodestly, that quite a few software developers would never get the chance to use it solving a task that they might encount in their work . This is Full Outer Join.
2013-11-01
How to configure ODBC DSN to access local DB2 for Windows
This article introduces how to configure ODBC DSN in Server to access local DB2 for windows in detail. Then I give a sample how to access local DB2 database with ODBC by DB Query Analyzer expediently.
2013-10-25
The 1st tip of DB Query Analyzer
DB Query Analyzer provides a useful function that you can sort a field of result in grid by click the title. Once click will sort by ascending. Click again will alter to descending.
2013-10-18
The 3rd tip of DB Query Analyzer
It's very convenient to annotate some script in DB Query Analyzer. Two ways are provided for you to annotate some script. Furthermore, you can execute selected SQL statement only.
2013-10-05
The 4th tip of DB Query Analyzer
DB Query Analyzer has a useful function to select a row in grid filled with query record set returned by RDBMS.
2013-09-27
The 5th tip of DB Query Analyzer
In DB Query Analyzer, it's very convenient to search key word in SQL edit/ Result area.
2013-09-20
万能数据库查询分析器使用技巧之（十三）
本文详细地介绍了"万能数据库查询分析器"，中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》在 EXCEL文件 处理方面非常强大的功能，要注意的是，EXCEL文件的第一行需要有列名。从5.03版本开始，"万能数据库查询分析器"会在自动生成的3大常用SQL语句中，自动为EXCEL、TXT/CSV数据源的表名前后增加方括弧。
2013-09-13
DB Query Analyzer 5.04 is released, 63 articles concerned have been published
DB Query Analyzer 5.04 is released, 63 articles concerned have been published.
In 5.04, it strengthens the support to Sybase Adaptive Server Enterprise (ACE) 15.
2013-09-10
The 13th tip of DB Query Analyzer, powerful processing EXCEL file
It‘s very powerful for DB Query Analyzer in EXCEL file processing. I’ll give you a sample to show its powerful function. Please make sure that column name coinciding with the data should be included in the first row in EXCEL file.
From 5.03, the table name will be enclosed in square bracket automatically by DB Query Analyzer while accessing the ODBC Data source based on MS EXCEL.
2013-09-07
How to configure ODBC DSN in Client to access DB2 for Windows.
This article introduces how to configure ODBC DSN in Client to access remote DB2 for windows in detail. Then I give a sample how to access remote DB2 database with ODBC by DB Query Analyzer expediently.
It’s also applicable to configure ODBC DSN to access remote DB2 for other OS such as Aix, Linux, Solaris and so on.
2013-08-24
Data access between different DBMS and other txtcsv data source
In this essay, I will show you an example about data access between different DBMS and other txt/csv data source by DB Query Analyzer
2017-01-11
Save results to different files in DB Query Analyzer
You can save each result to different file when executing multi SQL scripts In DB Query Analyzer 7.01 .
2016-11-21
SQL executing schedule monthly/weekly in DB Query Analyzer 7.01
DB Query Analyzer 7.01 allows usersto define monthly or weekly SQL executing plans. Here I will show you how the powerful function works.
2016-11-12
How to generate the complex data regularly by DB Query Analyzer
Considering the complex of the data required by Ministry of Transport of P.R.C every period of ten days, I design the following algorithm to generate the data required.
2016-06-17
如何使用《DB 查询分析器》高效地生成旬报货运量数据
本文将以中文版本《DB 查询分析器》6.04版本为例，详细介绍 如何使用它的执行计划功能，来组装起来各个算法脚本，来高效地生成交通部复杂的旬报货运量数据。
2016-06-09
An universal algorithm design of locating fixed length string
String locating is a very common operation not only in the SQL design but also in the client development tools, in which functions are also supplied to realize the locating operation, such as the 'LOCATE' function in DB2 or 'POS function in DELPHI.
In fact, we may meet with the special string locating, such as, we have to locate fixed length string locating, in which you may get the wrong result if you use the given 'LOCATE or 'POS function. In the essay, I give an algorithm that you can easily transform to other DBMS or client development tools.
2015-12-04
Install and run DB Query Analyzer 6.04 on Microsoft Windows 10
DB Query Analyzer lets you query ODBC data sources, author SQL scripts and queries, return query results to a grid or free-form text or a file, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously, and more. Also, it can be used in any Windows OS.
Now DB Query Analyzer is the top 10 database application software in the famous software website Zhongguancun Online . It has been download more than 110,000 times.
2015-09-01
DB Query Analyzer 6.04 is distributed, 78 articles concerned have been published
DB Query Analyzer is one of the few excellent Client Tools in the world for its’ powerful function, friendly interface, easy operation and applicability to every production of RDBMS.
In 6.04, It resolve the BUG that error message will be prompted when executing a single long SQL script with more than thousands of line or the file size of single SQL script more than 200KB.
2015-08-20
DB 查询分析器 6.04 发布，本人为之撰写的相关技术文章达78篇
万能数据库查询分析器，中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》。它具有强大的功能、友好的操作界面、良好的操作性、跨越各种数据库平台乃至于EXCEL和文本文件。
万能数据库查询分析器，中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》。它具有强大的功能、友好的操作界面、良好的操作性、跨越各种数据库平台乃至于EXCEL和文本文件。
2015-08-19
DB 查询分析器 方便地创建DB2自定义函数
本文详细地介绍了“万能数据库查询分析器”，中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》6.03 来方便地创建DB2函数。创建DB2存贮过程与此相同，大家可以参照以下步骤。另外，本示例还适用于SQL语句要以逗号来分隔的数据库系统（如ORACLE）。
2015-06-02
How to easily create DB2 user function by DB Query Analyzer 6.03
This essay gives a demonstration of creating DB2 user function easily by DB Query Analyzer. And also the creating process of stored procedure has no difference with that of function What’s more, the process of creating user function is also applicable to other DBMS, in which comma is the separator character between SQL statements.
2015-05-12
DB Query Analyzer 6.03 on Microsoft Windows 8
This essay gives a demonstration of DB Query Analyzer Installation and Running on Microsoft Windows 8.
The latest version of DB Query Analyzer is 6.03, which resolves the BUG which is caused by the default setting of short date separator character ‘/’ in Windows OS such as Windows 7, Windows 8 and Windows 10.
2015-01-09
《万能数据库查询分析器》创作人之2014年总结
2014年即将过去，特此总结一篇，也作为一年来自己为推广自己个人开发的软件产品---“万能数据库查询分析器”（ 中文版本《DB 查询分析器》、英文版本《DB Query Analyzer》 ）的一个见证。
2014-12-29
DB Query Analyzer 6.03, the most excellent UDA tools on any Microsoft Windows OS
From 6.01, DB Query Analyzer provides SQL Execute Schedule function to execute SQL scripts in certain time. Without changing any Windows OS settings or configurations, DB Query Analyzer 6.03 can run on any Microsoft Windows OS directly.
DB Query Analyzer is one of the few excellent Client Tools in the world for its' powerful function, friendly interface, easy operation and applicability to every production of RDBMS.
2014-12-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人