bradleyhorn
Technical User
Hi All,
In some tables brought over from Access into SQL-Server I have some auto number fields. They were brought into SQL-Server with a datatype of Int, length of 4, precision of 10. Since the length is 4 does this mean that there are only 10,000 possible values for this auto number field? Should I change datatype if I expect more than 10,000 entries in this table? To change the lenth of this auto-number field it seems to want me to change the datatype. Should I change it to numeric? Will the idendity property be supported by the numeric datatype?
Bradley
In some tables brought over from Access into SQL-Server I have some auto number fields. They were brought into SQL-Server with a datatype of Int, length of 4, precision of 10. Since the length is 4 does this mean that there are only 10,000 possible values for this auto number field? Should I change datatype if I expect more than 10,000 entries in this table? To change the lenth of this auto-number field it seems to want me to change the datatype. Should I change it to numeric? Will the idendity property be supported by the numeric datatype?
Bradley