Database Normalization
2021-09-01Database Normalization 是一種減少資料重複性,及確保資料一致性的過程
共有六個正規化,First Normal Form (1NF) 到 Sixth Normal Form (6NF),大部分的 database 都是到 Third Normal Form (3NF)
【MSSQL】Derived tables and common table expressions
2021-09-01- View
- Temporary Tables
- Table Variable
- Derived Tables
- CTE (Common Table Expression)
【MSSQL】Temporary tables
2021-08-26temporary table 被建立在 TempDB,且當 connection 關閉後會自動被刪除
- Permanent table
- Local temporary table
- Global temporary table
【MSSQL】Important concepts related to functions
2021-08-25- Deterministic and Nondeterministic Functions
- Deterministic functions
- Nondeterministic functions
- RAND() function
- WITH ENCRYPTION
- WITH SCHEMABINDING
【MSSQL】User-defined functions (UDF)
2021-08-25- Scalar functions
- Inline table-valued functions
- Multistatement table-valued functions
【SQL】Cascading referential integrity constraint
2021-08-23Cascading referential integrity constraint
用來定義使用者 UPDATE 或是 DELETE「FK」時的動作
1