You should always include an identity key column in your tables designing. Then it doesn't matter with the type of primary key column.

Let's say you want 4 columns in...

Hi,

This is not an issue of SELECT, AutoIncrement ID/IDENTITY nor SQL Server's. I am not going to tell what's behind the scene in SQL databases. In any RDBMS...