title: How can I insert identity manually?
body: <pre><code>CREATE TABLE masterTbl (
  id INT IDENTITY(1,1) CONSTRAINT pk_id PRIMARY KEY,
  name VARCHAR(100))
  
  INSERT INTO masterTbl VALUES ('ABC', 'XYZ','PQR')
  </code></pre>
  
  <p>Now</p>
  
  <pre><code>Select * FROM masterTbl
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>id  | name
  ---------------------
  1 |  ABC
  2 |  XYZ
  3 |  PQR
  
  DELETE FROM masterTbl WHERE id=1
  </code></pre>
  
  <p>Now</p>
  
  <pre><code>Select * FROM masterTbl
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>id |  name
  ---------------------
  2 |  XYZ
  3 |  PQR
  </code></pre>
  
  <p>Now I want to run:</p>
  
  <pre><code>INSERT INTO masterTbl (id, name) VALUES (1, 'MNO')
  </code></pre>
  
  <p>How is this possible?</p>