title: How to Insert Row Without Auto incrementing a ID Column
body: <p>I have a table that has a forced auto increment column. but some time i have to insert the value explicitly. For this purpose i set identity to on but it's not workin</p>
  
  <p>Here is the code:</p>
  
  <pre><code>SET IDENTITY_INSERT [menu_code] on
  
  INSERT INTO [dbo].[menu_code]
  VALUES('', '', '', '', '',
         1  -- Auto Generated Identity column
          ,'', '')
  </code></pre>