A-How's BLOG

• View
• Temporary Tables
• Table Variable
• Derived Tables
• CTE (Common Table Expression)

temporary table 被建立在 TempDB，且當 connection 關閉後會自動被刪除

• Permanent table
• Local temporary table
• Global temporary table

• Deterministic and Nondeterministic Functions
  • Deterministic functions
  • Nondeterministic functions
  • RAND() function
• WITH ENCRYPTION
• WITH SCHEMABINDING

• Scalar functions
• Inline table-valued functions
• Multistatement table-valued functions

用來儲存 SQL query，可以看作是 virtual table

• Views
• Indexed views

突然發現常常忘記一些基本中的基本，
來寫一下筆記幫助記憶

Cascading referential integrity constraint
用來定義使用者 UPDATE 或是 DELETE「FK」時的動作