How To Generate Auto Increment Serial number in SQL Server (MSSql) 

Create Auto increment id in sql server database table. here id is the column name which is of integer type. You can give any name to your column.