What's difference between IDENTITY and IDENTITY(1,1) in SQL?
CREATE TABLE tblSample ( UID INT NOT NULL IDENTITY, FName NVARCHAR(250), LName NVARCHAR(250) ); CREATE TABLE tblSample ( UID INT NOT NULL IDENTITY(1,1), FName NVARCHAR(250), LName NVARCHAR(250) );