title: IDENTITY_INSERT is set to OFF?
body: <p>Here is my script of my db ,</p>
  
  <pre><code>CREATE TABLE [dbo].[MyTable](
  [ID] [int] IDENTITY(1,1) NOT NULL,
  [Code] [nvarchar](25) NULL,
  [Name] [nvarchar](25) NULL,
  [dob] [date] NULL ,
   CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED 
    (
  [ID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,     
    ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     ) ON [PRIMARY]
  </code></pre>
  
  <p>When I insert , I got this error </p>
  
  <pre><code>Cannot insert explicit value for identity column in table 'MyTable' when   
  IDENTITY_INSERT is set to OFF.
  </code></pre>
  
  <p>How can I solve it ?</p>