At the request of a friend susue, I want to publish a new version of susue ~ By the way, I hope you can give me some comments ~ Thank you ~ The running effect is as follows:
A. NET Framework is required
Superficial, with less than 50 lines of code
SQL Server Query Analyzer of B/S by susue 2005-2-26
SQL Server
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 tabl
server| Query Analysis
These days in the web development, often need to connect SQL Server, but SQL Server is the server on the Internet, the service provider gave a sqlconnectionstring, However, in the connection string found that the SQL Server does not use the default 1433 port, so I would like to
Several problems encountered when reading Excel in the sql2005 query analyzer, collected all the resources on the Internet, and finally solved the problem. Many answers on the Internet are pasted and copied, therefore, it cannot be used in the actual environment. I believe many of my friends have encountered the same mistakes. To avoid the same mistakes, I would like to share them with you:Environment:Syste
The following table lists all keyboard shortcuts provided by the SQL Server Query analyzer.
Activity shortcuts
Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2
Bookmarks: insert or delete bookmarks (switch ). CTRL + F2
Bookmarks: Move to the next bookmarks. F2 function key
Bookmarks: Move to the previous bookmarks. SHIFT + F2
Cancel
If the primary database fails, Microsoft's SQL Server may enthusiasts down. See how you can handle this event to find out how to repair the primary database with Enterprise Manager and Query Analyzer.
As an administrator of Microsoft SQL Server, you must know how to fix a crashed primary database. The primary database
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 t
Many people in the use of SQL Server Query Analyzer will encounter a problem, that is, the operation of the official library, worry about additions and deletions in case the wrong thing to do? The data is priceless!Do we have to write a business statement every time to do this thing?SMSS has actually provided me with a function to open the transaction on the
. Ctrl+hEDIT: Select All. CTRL + AEdit: Undo. CTRL + ZExecutes the query. You can also use ctrl+e (for backward compatibility). F5 function keysSQL Query Analyzer Help. F1 function keysHelp for the selected Transact-SQL statement. Shift+f1Browse: Toggle between the query pan
/CSV files, and EXCEL files in the world.②You can execute multiple DML statements and even the storage process at the same time, and the results will be returned in the table, text box, and file you set;③When exporting tens of millions of data records from a database, the efficiency is no different from that of DBMS;④With the powerful SQL "Execution Plan" function, you only need to set the option "SQL Execu
Analyzer and English version DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.
You can use it①Query ODBC data sources (including all databases, TXT/CSV files, and EXCEL files in the world.②You can execut
XP, Windows 2000, Windows NT, Windows ME, Windows 9X.
Figure 1 PC Client that has installed Windows 8.1Figure 2 PC Client that has installed Windows 8.1
Figure 3 Install DB Query Analyzer on Windows 8.1
Figure 4 Install DB Query Analyzer on Windows 8.1
Figure 5 Install DB Q
personal software. Up to now, the most famous software download Website "Zhongguancun online" in China has downloaded nearly 90 thousand downloads, ranking first among the top 20 in the database category.
By November 9, 2011, Google searched for the keywords "DB query analyzer" and "DB query
records from a database, the efficiency is no different from that of DBMS.
The Chinese version of "DB query analyzer" has been downloaded online for more than 90 thousand times in Zhongguancun, ranking first 20 in the database category list.
In the "New Product tool comments" section of "programmer" 2007, "Special Recommendation" was edited and the "universal d
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
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
criteria, and the corresponding grouping is found. However, the intermediate table we get is the group number. Then we have to convert the corresponding time according to the group number: Logtime=group_num*5/1440+to_date (date, ' Yyyy-mm-dd ') So: SELECT (To_date (DATE, ' yyyy-mm-dd hh24:mi ') + Group_num * 5/(each)) LogTimeSo we can query the condition by the point of time 1. The specific SQL statement
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
: the user does not need to manage the transaction, and the background database manages the transaction. In most cases, users usually adopt this mode. For example, when data is deleted, after the delete operation is completed, the record is deleted.
(2) manual Transaction Management: you can manage the transaction on your own. You can use parameter settings to SET transaction control to manual transaction management, so that SQL statements executed in
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.