Question

which of the data type is most suitable for primary key​

Answer 1

Answer:

Data Type Integer

Data Type. Integer (number) data types are the best choice for primary key, followed by fixed-length character data types. SQL Server processes number data type values faster than character data type values because it converts characters to ASCII equivalent values before processing, which is an extra step.