title: How to insert identity column in SQL Server with null values like in MySQL
body: <p>How to insert identity column in SQL Server with null values like in MySQL?</p>
  
  <p>In MySQL we can place null and insert values for auto incremented columns. How to do this in SQL Server?</p>
  
  <p>Example:</p>
  
  <p>In MySql :</p>
  
  <pre><code>CREATE TABLE `employee` (
    `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(45) NOT NULL,
    `phone` VARCHAR(45),
    `salary` DOUBLE NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`)
  )
  ENGINE = InnoDB;
  </code></pre>
  
  <p>In the above table id is auto inc which means identity in SQL Server, to insert values into the above table MySQL supports the below query</p>
  
  <pre><code>INSERT INTO `employee` (`id`,`name`,`phone`,`salary`) 
  VALUES (null,'Harry','9985099850',60000);
  </code></pre>
  
  <p>MySQL automatically insert auto inc id to the identity column, but how to do this is SQL Server?</p>
  
  <p>Please guide me how to do this in SQL Server. I am struggling here from days to solve this in my application using JDBC. </p>