Implementation method for automatically converting and executing parameterized SQL based on Excel

An implementation method and automatic conversion technology, which is applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of error-prone, complicated and cumbersome processes, and reduce the efficiency of product maintenance by R&D personnel, so as to enhance the accuracy of execution. improve the efficiency of R&D and maintenance

Inactive Publication Date: 2018-10-16
SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During specific execution, it is necessary to connect to the database for replication, and add or delete executable SQL, which makes the whole process complicated and cumbersome, prone to errors, and greatly reduces the efficiency of product maintenance by R&D personnel

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Implementation method for automatically converting and executing parameterized SQL based on Excel
  • Implementation method for automatically converting and executing parameterized SQL based on Excel
  • Implementation method for automatically converting and executing parameterized SQL based on Excel

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The content of the present invention is described in more detail below:

[0025] Operation steps of the present invention are as follows:

[0026] 1) Write an extended application program for Excel

[0027] Using VBA language;

[0028] directly applied to Excel;

[0029] 2) Add in the add-in

[0030] Select the add-in in the options, and add the written program to it

[0031] Four functions can be selected directly in the add-in

[0032] 3) Select specific functions based on 1 and 2

[0033] Format traced SQL

[0034] Execute SQL, and the formatted SQL can be directly connected to the database for execution;

[0035] Get the column information of the table;

[0036] Generate entity classes.

[0037] First, developers add extension applications to Excel's add-ins.

[0038] Main program components:

[0039]

[0040]

[0041]

[0042]

[0043]

[0044]

[0045]

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides an implementation method for automatically converting and executing parameterized SQL based on Excel, belongs to technical field of computer applications, the performance of a automatic conversion SQL can help developers to execute the SQL language quickly, convert basic parameterized SQL, stored process SQL, tree help, etc, tracked by the event tracker into executable SQL quickly, and can connect the database to execute directly and check result. Project research and development and maintenance efficiency. The invention is good in use effect in EPR system project maintenance, and is also suitable for other systems.

Description

technical field [0001] The invention relates to computer application technology, in particular to an Excel-based method for automatically converting and executing parameterized SQL. For professional technicians, this technology can be used to automatically parameterize the traced SQL in Excel, and connect to the database for direct execution. Background technique [0002] In some systems, during software development and maintenance, the server-side event viewer will be used to trace SQL and execute the viewing method to troubleshoot problems. However, the SQL traced by the event viewer includes basic parameterized SQL, stored procedure SQL, tree help, etc., and there are many types. During specific execution, it is necessary to connect to the database for replication, and add or delete executable SQL, which makes the whole process complicated and cumbersome, prone to errors, and greatly reduces the efficiency of R&D personnel in product maintenance. Contents of the invent...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F8/30G06F17/30
CPCG06F8/31
Inventor 闫天航
Owner SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap