Saturday 19 July 2014

Create SQL Auto Increment Column (ID: Primary Key) in Table

Create SQL Auto Increment Column (ID: Primary Key) in Table
CREATE TABLE [MyTable]
(
[SNo] int IDENTITY(1,1)NOT NULL PRIMARY KEY,
[Compamy] [nvarchar](max) NULL,
}