Insert Multiple Records using a Single insert statement

  • Comments posted to this topic are about the item Insert Multiple Records using a Single insert statement

  • hi vikram ,

    Pls don't waste others time

    your article --- what is this ?

    Insert Multiple Records using a Single insert statement

    By vikram kharbanda,

    Total article views: 156 | Views in the last 30 days: 25

    Rate this | Join the discussion | Briefcase | Print

    1.)Rght Click on the database that contains the your original table.

    2.) Open new Query Window

    3.)Paste this into query

    5.)Replace the YourDATBSE with your own databse

    6.)Replace the MYTableNAME with your own tabl name

    USE YourDATBSE

    GO

    INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn)

    VALUES ('FirstRec',1);

    INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn)

    VALUES ('SecondRec',2);

    INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn)

    VALUES ('ThirdREC',3);

    INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn)

    VALUES ('FourthREC',4);

    INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn)

    VALUES ('FifthREC',5);

    GO

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply