Please enable JavaScript.
Coggle requires JavaScript to display documents.
T-SQL (table expressions (view (CREATE VIEW ....v....
AS
SELECT... (you…
T-SQL
table expressions
-
temporary table
CREATE TABLE # ....
(col_name, d_type)
-
table variable
DECLARE @variable_name AS TABLE (col_name, d_type) [#](#f66d94)
-
table-valued functions
CREATE FUNCTION .*schema*.udf_....( @variable_name AS d_type)
RETURNS TABLE
AS
RETURN
(SELECT
FROM
WHERE variable_name = @variable_name
)
-
common table expressions
WITH *CTE_*..... (col1_name, col2_name, ...)
AS
(
SELECT ...
FROM...
)
-
-
subqueries
-
correlated subquerie 
-
-
joins
types
- INNER (default)
- LEFT
- RIGHT
- LEFT OUTER
- RIGHT OUTER
-
-
-
-