I do not know how to do INSERT of tables nxn

0
CREATE TABLE pacotes 
(
    id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
    nome VARCHAR(100),
    valor FLOAT,
    percentual_max_desconto TINYINT,
);

CREATE TABLE pontos_turisticos 
(
    id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,  
    id_endereco INT,
    nome VARCHAR(100) NOT NULL,
    FOREIGN KEY (id_endereco) REFERENCES enderecos(id)
);


CREATE TABLE pacotes_pontos_turisticos 
(
    id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
    id_ponto_turistico INT,
    id_pacote INT ,
    FOREIGN KEY (id_ponto_turistico) REFERENCES pontos_turisticos(id),
    FOREIGN KEY (id_pacote) REFERENCES pacotes(id),
); 

I need to do INSERT but I do not know how.

    
asked by anonymous 31.08.2018 / 21:39

0 answers