Skip to main content

Return to Answer

Defined code block
Source Link
davmos
davmos
  • 9.6k
  • 4
  • 45
  • 46

It is possible to insert more than one row at a time.

For e.g., to insert 30 rows. INSERT INTO GroupTable DEFAULT VALUES GO 30..

INSERT INTO GroupTable DEFAULT VALUES
GO 30

This will insert 30 rows by incrementing the identity column each time.

It is possible to insert more than one row at a time.

For e.g., to insert 30 rows. INSERT INTO GroupTable DEFAULT VALUES GO 30

This will insert 30 rows by incrementing the identity column each time.

It is possible to insert more than one row at a time.

For e.g., to insert 30 rows...

INSERT INTO GroupTable DEFAULT VALUES
GO 30

This will insert 30 rows by incrementing the identity column each time.

Source Link
RMK
RMK
  • 29
  • 1

It is possible to insert more than one row at a time.

For e.g., to insert 30 rows. INSERT INTO GroupTable DEFAULT VALUES GO 30

This will insert 30 rows by incrementing the identity column each time.