identity - Best Method to Create and Use Customer Account Numbers in SQL Server 2008 SR2 -


I'm not a DBA, so I'm scratching my head a bit. I am trying to apply together for the company I work for. I need to provide a unique client account number for each office location on which my company does the business.

In the past, I have determined to use the enhanced identity number of the client account on the basis of the INTP column setup that opened the primary account. I am thinking that this is the best or the bad choice for such information.

What would you recommend? Thanks in advance for your help.

I use a natural key, if you can find a meaningless key The problem is that you can end up with duplicates that are difficult to identify.

Comments