technical articles on "universal database query analyzer ".
Currently, the following six articles are published in several Chinese computer publications:
[1] Ma genfeng-DB QueryAnalyzer interrupted SQL statement execution · Hangzhou: computer age, Issue 1, 12th
[2] Ma genfeng-DB query analyzer executes DML statements
DBMS in Computer Engineering Software 6th issue of 2011 in Tianjin.
The Application of the Transactions Control in Oracle with DB Query Analyzer in Microcomputer Applications11th issue of 2011 in Shanghai.
DB Query Analyzer had been stronugly recommended In the New product
maintenance, management, and development. Every programmer wants to perform database transaction operations conveniently and securely, while DB Query Analyzer meets this requirement.
References:
[1]Zhang longxiang, Huang zhengduan, Tao Ying· Database principles and Design · CHENGDU: Southwest Jiaotong University Press, 1995.
[2]Application of transaction control of ActiveX Data Objects in VB and DELPHI ·
35. use SQL query analyzer and SQL profilerUse SQL query AnalyzerUse SQL profilerOptimize T-SQL statementSummaryIn this chapter, we will continue with the description of the pre-stored procedures in Chapter 21st. This chapter describes how to use SQL query analyzer and SQL p
As an IT expert who has been learning computer technology since 1992, I have been asking myself for "diligence, thinking," and my strong interest and thirst for knowledge in computer science, in 1999, I started my three-year postgraduate study in the computer technology field.
Windows-based development tools, including Vb, Delphi, Power Builder, and VC. In terms of database systems, we have studied and used databases such as ms SQL Server, Oracle, Syb
The 10th tip of DB query Analyzer
-- Higher efficiency to export SQL result by DB query analyzer than B2
Ma gen-Feng
(Guangdong unitoll services ininitialized ated, Guangzhou 510300)
AbstractIn the latest version 4.01, a useful function is added in dB query
Alibaba Cloud SQL Intelligent Query analyzer, a database query and analysis management tool developed by delphi.
To facilitate your work, you can use a database query and analysis management tool developed by delphi to share with you the following features:
1. Due to the use of ADO connections, it theoretically sup
Tips for using the universal database query analyzer (16) --- SQL Execution Plan new in version 6.02 database connection Automatic Recovery Summary This article introduces the universal database query analyzer in detail, the SQL Execution Plan Database Connection automatic recovery function is added in the Chinese data
Tips for using the universal database query analyzer (10)
--- More efficient query result export function than DB2 Export
Magenfeng
(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China)
SummaryThis article describes in detail the "universal database query analyz
"Universal database query analyzer" 5.03 is released. Accessing EXCEL will automatically add brackets before and after the table name
1 Introduction
The personal work released by Jack Ma, a local programmer in China, is the universal database Query Analyzer. The Chinese version is DB
DB Query Analyzer 5.03 is distributed, table name will be enclosed in square bracket automatically while accessing MS EXCEL
1 Preface
DB Query Analyzer is presented by Master Gen feng, Ma from Chinese Mainland. it has English version named 'db Query
Enable AD Hoc distributed Queries: ' Show advanced Options ', 1
Reconfigure
' Ad Hoc distributed Queries ', 1
Reconfigure
When you are finished using, close ad Hoc distributed Queries:' Ad Hoc distributed Queries ', 0
Reconfigure
' Show advanced Options ', 0
Reconfigure
Operation:
' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password '
' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password '
' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password '
' SQLOLE
To facilitate their own work, the use of Delphi developed a database query analysis management tools. Share to everyone, the following characteristics:1. Due to the use of ADO connection, the theory supports all databases such as SQL Server, Access, MySQL, Oracle, etc.2. Support SQL keyword automatic prompt3. Support automatic prompt for table name4. Support table field automatic prompt5. Support sq keyword
partial database backup and file backup. The new restore statement allows you to use full or partial database backup and record file backup for restoration. These replace the dump and load statements in earlier versions of SQL Server. For a complete list of new statements and options for SQL Server 7.0 and SQL Server 2000, see the topic "new and enhanced functions of transact-SQL" in online books.How to Use T-SQL In addition to using T-SQL to design your applications (this topic is beyond the s
1 Introduction
The personal work released by Jack Ma, a local programmer in China, is the universal database query analyzer. The Chinese version is dB query analyzer and the English version is dB query analyzer.
Universal database
19.3.1 SQL Query Analyzer Introduction
SQL Query Analyzer is a graphical management tool that is used to write, test Transact-SQL statements, and batch processing. System administrators and developers can learn how to improve performance of query execution by executing mult
Use the query analyzer to adjust the SQL Server script. I like to think of the tools bundled with SQL servers as inverted pyramid. tools for diagnosing and checking general problems are at the top, and tools for finding and diagnosing specific areas of problems are at the bottom. Apart from mentioning that I like to regard the tools bundled with SQL Server as inverted pyramid, the tools for diagnosing and c
Dex introduces mongodb index and query analyzer dex. It is a MongoDB performance adjustment tool that compares MongoDB log files and index entries and provides index recommendations. Currently, you must provide a URI to connect to the database. Dex only recommends full indexes, not partial indexes. Windows platforms are not supported. Dex working principle dex is mainly used during operation
Dex introduces
Query Analysis | server | script
I like to think of the tools bundled with SQL Server as inverted pyramid, the tools for diagnosing and checking general problems at the top, looking for and diagnosing specific areas of problems at the bottom. In addition to providing a convenient way to write SQL scripts, Query Analyzer is the resource that you need to use when y
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.