动态SQL在企业综合管理系统中的实现

Implementation of Dynamic State SQL in Enterprise Comprehensive Management System

在B/S结构的综合管理系统中,动态SQL是一种可以满足后台数据库系统日益增长的自动化和智能化要求的技术。本文以SQL Server中动态SQL在企业综合管理系统中的应用为例,介绍了动态SQL的两种执行方法,讨论了动态SQL两种方法的特点,研究了动态SQL在工程中的应用条件,给出了动态SQL两种方式在企业综合管理系统中的应用过程。工程应用证明,动态SQL的使用,增强了数据库的查询功能,提高了系统解决问题的能力。

In the comprehensive management system based on B/S construction,the dynamic state SQL technology can get the increasingly automatic and intelligent demands of the background database system. The dynamic state SQL technology＇s application in business enterprise is taken as the example. Two kinds of performance methods of dynamic state SQL in the SQL Server are introduced;the characteristics of two kinds of methods of the dynamic state SQL are discussed. The applying condition of dynamic state SQL in the engineering is studied,and the applying process of two kinds of methods in dynamic state SQL in the business enterprise is given. The engineering application shows that the query function of the database is enforced and that the problem-solving ability of the system is improved through the usage of dynamic state SQL.