SQL外连接查询在系统开发中的应用  

Application of SQL Outer Join in System Development

作　　者：王平勤[1] 董付国[1] 周翔凤[1] 

机构地区：[1]山东工商学院,烟台264005

出　　处：《电脑开发与应用》2008年第3期57-58,共2页Computer Development & Applications

摘　　要：介绍了ASP.NET/C#对SQL语句的调用和执行方法与技术,重点介绍了外连接查询SQL语句的编写技巧以及在系统开发中的应用。大量应用证明,正确使用外连接查询不仅可以减少网络数据流量,更重要的是提高了系统的运行效率。最后,通过一个在某公司生产监督管理系统开发中的实际案例介绍了外连接查询和子查询技术的应用。Calling and execution of SQL sentence in ASP. NET/C# environment is introduced in this paper, the skill to design outer join SQL sentence and its application in the system development are discussed as well. Correct use of outer join query technology can not only reduce the data flow on the network, but also improve the efficiency of system. The application of outer join query and child-query technology is discussed through an example.

关 键 词：连接查询 SQL语句 数据库 

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