INSERT [INTO] { table_name [ WITH ( <table_hint_limited> [...] ) ] | 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 } |
参数 | 意义 |
---|---|
column_list | 指定设置值的列,尽量不要省略此项,以使代码维护变得困难 |
derived_table | SELECT 查询语句,返回需要插入的数据(多行) |
execute_statement | EXECUTE 执行语句,返回需要插入的数据(多行) |
INSERT INTO T1(NAME) SELECT NAME FROM T2 |