How To Generate Auto Increment Serial number in SQL Server (MSSql) Pranav anand 2 years ago 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.