-- 0)
USE tempdb;

DROP TABLE IF EXISTS T;

CREATE TABLE T(col1 INT);

-- 1) INSERT pomocou VALUES
-- INSERT [INTO] T VALUES(1)
INSERT T VALUES(1);
INSERT T VALUES(2), (3), (4);

-- 2) INSERT pomocou SELECT UNION ALL
INSERT T
SELECT 5 UNION ALL
SELECT 6 UNION ALL
SELECT 7
SELECT * FROM T;

-- 3) INSERT pomocou SELECT
INSERT T SELECT * FROM T;
SELECT * FROM T;

-- 4) vkladaj pomocou INTO bez CREATE a INSERT
IF OBJECT_ID ('#B') IS NOT NULL DROP TABLE #B;
-- Bez CREATE TABLE!!! FROM nutne! Prejde aj bez #
SELECT * INTO #B FROM T;
SELECT * FROM #B;