How to insert data in a batch?

 

This question already has an answer here:

  • Inserting multiple rows in a single SQL query? [duplicate] 4 answers

    • If you have this definition: 

    CREATE TABLE t (id int IDENTITY(1,1) PRIMARY KEY)

    Then you can do this: 

    INSERT t DEFAULT VALUES
INSERT t DEFAULT VALUES
INSERT t DEFAULT VALUES
INSERT t DEFAULT VALUES
INSERT t DEFAULT VALUES
    链接地址: http://www.djcxy.com/p/94498.html

    上一篇: 在Oracle中插入行？

    下一篇: 如何批量插入数据？