数据库原理与应用 附录A 常用T SQL语句快速参考.docVIP

附录A 常用T-SQL语句快速参考 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 ] 2．INSERT 语法格式为： INSERT [ INTO] { table_name WITH ( table_hint_limited [ ...n ] ) | view_name | rowset_function_limited } { [ ( column_list ) ] { VALUES ( { DEFAULT | NULL | expression } [ ,...n] ) | derived_table | execute_statement } } | DEFAULT VALUES table_hint_limited ::= { FASTFIRSTROW | HOLDLOCK | PAGLOCK | READCOMMITTED | REPEATABLEREAD | ROWLOCK | SERIALIZABLE | TABLOCK | TABLOCKX | UPDLOCK } 3．DELETE 语法格式为： DELETE [ FROM ] { table_name WITH ( table_hint_limited [ ...n ] ) | view_name | rowset_function_limited } [ FROM { table_source } [ ,...n ] ] [ WHERE { search_condition | { [ CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ] } } ] [ OPTION ( query_hint [ ,...n ] ) ] table_source ::= table_name [ [ AS ] table_alias ] [ WITH ( table_hint [ ,...n ] ) ] | view_name [ [ AS ] table_alias ] | rowset_function [ [ AS ] table_alias ] | derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ] | joined_table joined_table ::= table_source join_type table_source ON search_condition | table_source CROSS JOIN table_source | joined_table join_type ::= [ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ] [ join_hint ] JOIN table_hint_limited ::= { FASTFIRSTROW | HOLDLOCK | P