摘要
在SQL Server 2000教学中,SQL查询语言是一个重点和难点,其中基于多表的查询尤为重要。我们一般使用联接查询或子查询处理涉及到多表的题目,发现学生不容易掌握。本文介绍了一种新的基于联接和子查询的组合查询设计方法。实践证明,该查询方法不仅可以提高查询效率,而且便于学生理解,扩展了学生的思路。
The content of Structured Query Language, especially the design of query based on multi-table, is important but difficult for students to understand in the process of studying SQL Server 2000. Usually, Joint or SubQuery language used to handle multitable problems causes students puzzled. To improve this kind of situation, a new design method--combined query, which can improve query efficiency and broaden their thoughts, is introduced in this paper.
出处
《农业网络信息》
2007年第4期119-121,共3页
Agriculture Network Information
