Id column based on other columns
Possible duplicate https://stackoverflow.com/questions/1545571/how-do-i-make-a-composite-key-with-sql-server-management-studio

It sounds like what you are wanting is a composite key.  There is a T-SQL example in the link provided.