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

Implementation of Dynamic State SQL in Enterprise Comprehensive Management System

作　　者：韩中华[1] 吴成东[1] 郑君刚[2] 

机构地区：[1]沈阳建筑大学信息与控制工程学院,沈阳110168 [2]沈阳建筑大学理学院,沈阳110168

出　　处：《自动化与仪表》2008年第3期48-50,54,共4页Automation & Instrumentation

基　　金：科技部国际合作重点项目基金资助(2003DF020009)

摘　　要：在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.

关 键 词：SQL SERVER 动态SOL 执行方法 优化查询 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]