title: How can I insert multiple records with a single INSERT statement in Sybase ASE
body: <p>This feature is available in <a href="https://stackoverflow.com/questions/4067113/how-to-insert-multiple-rows-in-single-insert-statement">MySQL as shown in this post</a> and according to the <a href="http://dcx.sybase.com/1200/en/dbreference/insert-statement.html" rel="nofollow noreferrer">Sybase documentation</a> it should also be supported, however Sybase don't provide a worked example so you have to interpret the following:</p>
  
  <p><strong><em>Syntax 1   Insert a single row, or multiple rows, with the specified expression column values. Multiple rows, if specified, are delimited by additional parentheses</em></strong></p>
  
  <p>So I interpret "additional parentheses" as expecting the following code to work</p>
  
  <pre><code>create table #tmp_codes (
      code varchar(12) NULL
  )
  
  insert into #tmp_codes (code) 
  values
      ('AAA'),
      ('BBB'),
      ('CCC')
  </code></pre>
  
  <p>However it errors with</p>
  
  <pre><code>Incorrect syntax near ',' on line 7
  </code></pre>
  
  <p>I'm using Sybase ASE 15 and cannot see any reference to inserting multiple rows <a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.commands/html/commands/commands62.htm" rel="nofollow noreferrer">on this support page for the INSERT statement</a></p>
  
  <p>Is this feature available in Sybase?</p>