SQL Server Primary Keys

Hi,
Int is OK, and you can also declare it as an identity, like

CREATE TABLE new_employees
(
 id_num int IDENTITY(1,1),
 fname varchar (20),
 minit char(1),
 lname varchar(30)
)

Select allOpen in new window

First thing that you should ask is: "Do I really need a GUID?"

As Expert says the GUID uses more resource to store the data.

 it took little more time to read the that column data, if you have large numbers of rows.

 If you declare it as the Primary column it will create the index on it and if you select Int as a type , Indexes will be more faster and efficient.

Thank You.