SQL Server 2000实用教程 第5章 表中数据的操作 .pdf

第5章 表中数据的操作 5.1 在企业管理器中操作表中的数据 5.2 使用SELECT语句查询数据 5.3 使用INSERT语句插入数据 5.4 使用UPDATE语句更新数据 5.5 使用DELETE语句删除数据 5.1 在企业管理器中操作表中的数据 查询 插入 更新 删除 本章首页 5.2 使用SELECT语句查询数据 SELECT语句的基本格式如下： SELECT select_list [ INTO new_table ] FROM table_source [ WHERE search_condition ] [ GROUP BY group_by_expression ] [ HAVING search_condition ] [ ORDER BY order_expression [ ASC | DESC ] ] 5.2 使用SELECT语句查询数据 5.2.1 SELECT子句 SELECT [ ALL | DISTINCT ] [ TOP n [ PERCENT ] [ WITH TIES ] ] select_list select_list ::= { * | { table_name | view_name | table_alias }.* | { column_name | expression | IDENTITYCOL | ROWGUIDCOL } [ [ AS ] column_alias ] 基本格式 | column_alias = expression } [ ,...n ] 5.2 使用SELECT语句查询数据 5.2.2 INTO子句 [ INTO new_table ] 基本格式 5.2 使用SELECT语句查询数据 5.2.3 FROM子句 [ FROM { table_source } [ ,...n ] ] table_source ::= table_name [ [ AS ] table_alias ] [ WITH ( table_hint [ ,...n ] ) ] | view_name [ [ AS ] table_alias ] | rowset_function [ [ AS ] table_alias ] | OPENXML | derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ] | joined_table 5.2 使用SELECT语句查询数据 joined_table ::= table_sourcejoin_type table_sourceONsearch_condition | table_source CROSS JOIN table_source | joined_table join_type ::= [ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ] [ join_hint ] 基本格式 JOIN 5