Most efficient way to store a GUID value in SQL Server database
You can use uniqueidentifier datatype
- Use the uniqueidentifier data type which is designed for GUIDs
For example, they will sort like GUIDs should - Create a UNIQUE index on it (more flexible than a unique constraint
Note, these are 2 separate steps