1、本文是中英对照毕业设计论文外文文献翻译， 下载后无需调整复杂的格式直接可 用！一辈子也就一次的事！ 文献引用作者出处信息: Diane_Zak,Database Queries with SQL Programming with Microsoft Visual Basi,2019:550-585 (如觉得年份太老，可改为近 2 年， 毕竟很多毕业生都这样做) 英文 3526 单词，20361 字符(字符就是印刷符)，中文 5774 汉字。（如果字数多 了，可自行删减，大多数学校都是要求选取外文的一部分内容进行翻译的。） Database Queries with SQL FOCUS ON T
2、HE CONCEPTS LESSON Concepts covered in this lesson: F-1 SELECT statement F-2 Creating a query F-3 Parameter queries F-4 Saving a query F-5 Invoking a query from code F-1 SELECT Statement The most commonly used statement in Structured Query Language, or SQL, is the SELECT statement. You use the SELEC
3、T statement to create database queries. As you learned in Chapter 11, a database query, often referred to more simply as a query, is a statement that allows you to retrieve specific information from a database. For example, you can use a query to specify the fields and records you want either to dis
4、play or to use in a calculation. The basic syntax of the SELECT statement is shown in Figure 12-1 along with some of the operators that can be included in the WHERE clauses condition. Capitalizing the boldfaced keywords in a SELECT statement is optional; however, many programmers do so for clarity. In the syntax, fieldList is one or more field names separated by commas, and table is the name of the table containing the fields. The WHERE and ORDER BYclauses are optional parts
