Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 16, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

SQL Adding Records

What is the syntax for inserting multiple records into a single query. I have some files with thousands of records to insert and it's too slow using Insert into x VALUES (a,b,c).

What I want to do is something like INSERT INTO x VALUES((a,b,c),(d,e,f)... As many as I can in one hit. I am using access as the DBMS and VB as the programming paradigm.

Depending on where you are inserting from (I'm guessing tables) you might try INSERT SELECT.

From BOL;
INSERT author_sales

    SELECT 'SELECT', authors.au_id, authors.au_lname, 

        SUM(titles.price * sales.qty) 

    FROM authors INNER JOIN titleauthor 

        ON authors.au_id = titleauthor.au_id INNER JOIN titles

        ON titleauthor.title_id = titles.title_id INNER JOIN sales

        ON titles.title_id = sales.title_id

    WHERE authors.au_id LIKE '8%'

    GROUP BY authors.au_id, authors.au_lname
DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date