title: INSERT INTO T-SQL statement
body: <p>Question: State what is wrong with the following T-SQL.</p>
  
  <pre><code>INSERT INTO dbo.[Pricing_ProductPrice]
  (DealerPrice,PricingRegion,ProductId,RetailPrice)
  VALUE
  ('70.00','635727362389933863','ZQ','99621-05V','120.00','A')
  </code></pre>
  
  <p>My Answer:</p>
  
  <p>I don't know if there are any more but this is what I have so far:</p>
  
  <ul>
  <li>USE statement is missing to use which database</li>
  <li>GO statement is    missing</li>
  <li>Pricing_Product Price table is around square brackets. No    brackets
  needed.</li>
  <li>Should be VALUES, not VALUE</li>
  <li>More values than    columns.  6 values going into 4 columns.</li>
  </ul>
  
  <p>Are there any more issues I am missing?</p>