【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