Avatar of pointeman
pointeman
Flag for United States of America asked on

SQL ID Column Uses Unique Row Data Vs Sequence Number?

I work at a company IT dept that never used sequectial number ID columns in data tables. They insist on using unique data per row in the ID column because the data (part number) makes more 'human readable' than a secequence number.

Q. What is the best practice?
Microsoft SQL Server

Avatar of undefined
Last Comment
Alpesh Patel

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kent Olsen

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pointeman

ASKER
The other part of their reasoning is making muti-table inserts easier. For instance, writing data in a foreign table and primary table without having to lookup the I'd columns max I'd number. They simply insert the part number in both tables I'd columns. I was not taught this way and it seems quite backwards.
SOLUTION
Kent Olsen

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Your help has saved me hundreds of hours of internet surfing.
fblack61