I have defined a PatientInfo table with following fields
PatientGUID uniqueidentifier not NULL
PatientID bigint not NULL
LastName Varchar(50) not NULL
FirstName Varchar(50) not NULL
Gender SmallInt not NULL
PatientID can be a incrementing number starting from 1 while PatientGUID has to be generated in such a way that no two patient records have same GUID even on different installations - may be adding NIC MAC address or something.
What is the best way to generate these IDs?