title: Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
body: <p>I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere due to pulling up tons of help docs and articles about "bulk imports".</p>
  
  <p>Here's what I want to do, but the syntax is not exactly right... please, someone who has done this before, help me out :)</p>
  
  <pre><code>INSERT INTO dbo.MyTable (ID, Name)
  VALUES (123, 'Timmy'),
      (124, 'Jonny'),
      (125, 'Sally')
  </code></pre>
  
  <p>I know that this is <em>close</em> to the right syntax. I might need the word "BULK" in there, or something, I can't remember. Any idea?</p>
  
  <p>I need this for a SQL Server 2005 database. I've tried this code, to no avail:</p>
  
  <pre><code>DECLARE @blah TABLE
  (
      ID INT NOT NULL PRIMARY KEY,
      Name VARCHAR(100) NOT NULL
  )
  
  INSERT INTO @blah (ID, Name)
      VALUES (123, 'Timmy')
      VALUES (124, 'Jonny')
      VALUES (125, 'Sally')
  
  SELECT * FROM @blah
  </code></pre>
  
  <p>I'm getting <code>Incorrect syntax near the keyword 'VALUES'.</code></p>