title: SQL Server, Problem creating temp table in TSQL
body: <p>Hi when i execute the following TSQL, i get the error message below. But there is nothing wrong with the SQL syntax is there?</p>
  
  <pre><code>create table #tb ([t1] tinyint, [t2] varchar(50))
  insert into #tb values
      (1, 'a'), 
      (2, 'b')
  </code></pre>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 3
    Incorrect syntax near ','.</p>
  </blockquote>
  
  <p>There is nothing else in the SQL query window. Running SQL Server 2005.</p>