title: SQL Server Invalid Column Name Error
body: <p>I have an invalid Column Name error when inserting a record to my SQL Server table. Here's the definition:</p>
  
  <pre><code>CREATE TABLE [dbo].[myTable] 
  (
      [id] int IDENTITY(1, 1) NOT NULL,
      [person_name] varchar(255) NOT NULL,
      [modified_By] varchar(255) NOT NULL
  )
  ON [PRIMARY] WITH (DATA_COMPRESSION = NONE);
  GO
  </code></pre>
  
  <p>And insert</p>
  
  <pre><code>INSERT INTO myDB.dbo.myTable (id, person_name, modified_By) 
  VALUES (1, 'Aishwarya', 'admin')
  </code></pre>
  
  <p>But I get the following error upon execution:</p>
  
  <blockquote>
    <p>Lookup Error - SQL Server Database Error: Invalid column name
    'modified_BY'.</p>
  </blockquote>
  
  <p>I can <code>SELECT</code> from the column fine. The only thing I've noticed in error is that "BY" is capitalized, contrary to the table definition. Any ideas?</p>
  
  <p>UPDATE: Updating all the syntax errors, apologeez</p>