In my Project table.
I have a column called projSeqNum (Project Sequence Number) I was with a fellow techie -data modeler- and I think it was just placed with an int data type. I think a 4 length.
My question is what would be the correct data type here. There could be 100's of thousands of unique Project ID's so I need something sturdy but not overboard.
Any ideas?
Should I use a varchar data type?|||Hi
The int datatype should be fine - it allows for numbers up to 2,147,483,647.
If that's not big enough, you could use bigint, which goes up to 9,223,372,036,854,775,807.
HTH
