A-How's BLOG

記錄一些筆記

Category: SQL 筆記

【MSSQL】Derived tables and common table expressions

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

【MSSQL】Temporary tables

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

  • Permanent table
  • Local temporary table
  • Global temporary table

【MSSQL】Important concepts related to functions

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

【MSSQL】User-defined functions (UDF)

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

【SQL】Views

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

  • Views
  • Indexed views

【SQL】基本中的基本

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

【SQL】Cascading referential integrity constraint

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

1