I want a bigint ID column for every row of data that i insert into a table. I want Sql server to generate the numbers. I tried to create a table with a bigint column ID. I want this to be autoincrement with the first value as 1. I tried using `[ID] [bigint] AUTO_INCREMENT NOT NULL,` in my create table statement, but I got the error - `Incorrect syntax near 'AUTO_INCREMENT'.` How do I do this ?