title: How to insert N rows of default values into a table
body: <p>I have a table containing an identity column as well as a column representing the creation date:</p>
  
  <pre><code>CREATE TABLE dbo.OrderStatus
  (
      OrderStatusId int IDENTITY(1, 1) NOT NULL,
      CreationDate datetime NOT NULL default GETDATE(),
      CONSTRAINT PK_OrderStatus PRIMARY KEY(OrderStatusId)
  )
  </code></pre>
  
  <p>Since the identity column generates a value by itself and the CreationDate is always going to be the current date (<code>GETDATE()</code>), I can add a row thanks to <code>DEFAULT VALUES</code>:</p>
  
  <pre><code>INSERT INTO dbo.OrderStatus DEFAULT VALUES;
  </code></pre>
  
  <p>But what can I do if I want to add, let's say, three records?</p>
  
  <p><strong>Current solution (edited some input since it didn't make any sense)</strong></p>
  
  <p>For now, in order to do what I want, I add several rows with <code>VALUES</code>:</p>
  
  <pre><code>INSERT INTO dbo.OrderStatus (CreationDate)
  VALUES  (GETDATE()), 
          (GETDATE()), 
          (GETDATE())
  </code></pre>
  
  <p>Although, I'd prefer to know the equivalent of <code>INSERT INTO .. DEFAULT VALUES</code> for multiple rows, in case that I add another column with a default value later on. </p>
  
  <p>Is there a way to insert N rows into a table with <code>DEFAULT VALUES</code> or in a similar way?</p>