日期:2014-05-17  浏览次数:20630 次

如何看懂SQL Server语法表达式
发现我看不懂语法,晕死了!
比如下面这个表达式:
-------------------------------------------
[ WITH <common_table_expression> [,...n] ]
MERGE 
  [ TOP ( expression ) [ PERCENT ] ] 
  [ INTO ] <target_table> [ WITH ( <merge_hint> ) ] [ [ AS ] table_alias ]
  USING <table_source> 
  ON <merge_search_condition>
  [ WHEN MATCHED [ AND <clause_search_condition> ]
  THEN <merge_matched> ] [ ...n ]
  [ WHEN NOT MATCHED [ BY TARGET ] [ AND <clause_search_condition> ]
  THEN <merge_not_matched> ]
  [ WHEN NOT MATCHED BY SOURCE [ AND <clause_search_condition> ]
  THEN <merge_matched> ] [ ...n ]
  [ <output_clause> ]
  [ OPTION ( <query_hint> [ ,...n ] ) ]  

--------------------------------------------
“[]”区域一般表示什么,“<>”什么意思,“()”什么意思,“...”什么意思。
最好把上面的语法示例翻译下给我,谢谢大侠们!!



------解决方案--------------------
联机帮助上写得很清楚的
http://msdn.microsoft.com/zh-cn/library/ms177563.aspx