Andmebaaside neljas kodutöö
Kodused ülesanded 4 Erilised tabelid
Tähtaeg: 5.12.2018
Ajutised andmed (ajutised tabelid, tabeli-väärtuselised muutujad ja -parameetrid):
DECLARE @FirstTable TABLE (RandomInteger INT)
DECLARE @i INT = 1
DECLARE @n INT = 100000
WHILE @i < @n+1
BEGIN
INSERT INTO @FirstTable
VALUES (@i)
SET @i =@i+1
END
SELECT * FROM @FirstTable
Tabeli-avaldised (CTE):
DECLARE @fibLen AS INT = 10;
WITH fibTable (rowNum, prevNum, fibNum)
AS
(
SELECT 1, 1, 1
UNION ALL
SELECT rowNum+1, fibNum, prevNum + fibNum
FROM fibTable
WHERE rowNum < @fibLen
)
SELECT fibNum
FROM FibTable;
GO
Graaf-tabelid:
SELECT DISTINCT Person.Name, Post.Content
FROM Person, Posted, Post, Likes
annaabi.ee 
