Home Forums SQL Server 2008 T-SQL (SS2K8) Primary Key Implementation Issue RE: Primary Key Implementation Issue

  • October 24, 2012 at 1:56 am

    #1552154

    Use surrogate Primary Key (the best and simple in in SQL server will be having INT IDENTITY PK, you don't need to add "firstname+lastname" to it). Use IndividualPersonalKey as another key which can be unique but null-able. It's quite common problem met by database designers and using surrogate keys does help to solve this problem in simple and elegant way.

    And...

    Disregard J.C. comments if he will post here and suggest using fake ones with later update to the real ones - huge headache for no gains!

    Can you be absolutely sure that whoever issue IndividualPersonalKey's will never decide to reuse ones?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]