Загрузка данных


DELETE FROM dbo.StrokaTTN;
DELETE FROM dbo.TTN;

DBCC CHECKIDENT ('dbo.StrokaTTN', RESEED, 0);
DBCC CHECKIDENT ('dbo.TTN', RESEED, 0);

INSERT INTO dbo.TTN
    (nomer, data_otgruzki, id_pokupatelya, summa)
VALUES
    ('TTN-2026-001', '2026-09-12', 1, 3200.00),
    ('TTN-2026-002', '2026-09-13', 2, 1250.00),
    ('TTN-2026-003', '2026-09-14', 3, 1800.00),
    ('TTN-2026-004', '2026-09-15', 4, 1300.00),
    ('TTN-2026-005', '2026-09-16', 5, 900.00);


INSERT INTO dbo.TTN
    (nomer, data_otgruzki, id_pokupatelya, summa)
VALUES
    ('TTN-2026-001', '2026-09-12', 1, 3200.00),
    ('TTN-2026-002', '2026-09-13', 2, 1250.00),
    ('TTN-2026-003', '2026-09-14', 3, 1800.00),
    ('TTN-2026-004', '2026-09-15', 4, 1300.00),
    ('TTN-2026-005', '2026-09-16', 5, 900.00);