title: How to insert queries with null values in SQL Server 2008
body: <p>How to insert queries with null values in SQL Server 2008?</p>
  
  <p>eg:</p>
  
  <pre><code>  INSERT INTO QREMOTES...Account 
    (Name, AccountType, ParentRefListID)
    VALUES
    ('Josh Account', 'Expense', NULL)
  </code></pre>
  
  <p>as I know null keyword is used.. but here it is not helpful its how me error </p>
  
  <blockquote>
    <p>Msg 7399, Level 16, State 1, Line 1<br>
    The OLE DB provider "MSDASQL" for linked server "QREMOTES" reported an error. The provider did not give any information about the error.<br>
    Msg 7343, Level 16, State 2, Line 1<br>
    The OLE DB provider "MSDASQL" for linked server "QREMOTES" could not INSERT INTO table "[QREMOTES]...[Account]". Unknown provider error.</p>
  </blockquote>