第七部分 数据的更新

1.	插入INSERT
INSERT [INTO]
{Table_name WITH (<table_hint_limited> […n]) | view_name | rowset_function_limited}
{
[(column_list)]
{VALUSE({DEFAULT | NULL |xepression} [,…n]) | derived_table | execute_statement}
}
2.	修改UPDATE
UPDATE table_name
SET | column_name =|expression |DEFAULT | NULL | [,…,n]|
[FROM table_name[,…]]
[WHERE<search_condition>]
3.	删除数据DELETE
DELETE table_name
[FROM table_name[,…,n]]
[WHERE | <search_conditon>| ]

 

posted @ 2012-11-15 17:45  i Traveling Light  阅读(98)  评论(0)    收藏  举报