As per the requirement, we are maintaning all the student details in excel sheet and based on their firstname and lastname and surname comibation we need to create user id and import into sqlserver table. We are maintaning userid and password columns in a table called users. We should maintain unique ness in the user id generation based on the student names. How can we do this in sql server.
asked May 10 '12 at 01:01 PM in Default
First, make sure that excel sheet records does not contain duplicates. I suggest you to use the auto numbering(Identity column) for userID this guarantees uniqueness and makes the clustered index key compact(as the userid is primary key)
answered May 10 '12 at 01:05 PM