SQL Server Requirements
A SQL Server table should have a primary key defined to ensure rows can be identified uniquely. The preferred mechanism is to define the primary key column as IDENTITY.
-
If the primary key column has an IDENTITY specification, it will be used for ID generation.
-
If the primary key does not have an IDENTITY specification then:
It is preferred that the table contain rows of like data type.