>> I have some table fields [sic] which were using automatic number as

> Hi, i have imported an access database into sqlserver 2000. In access,
> i have some table fields which were using automatic number as
> datatype. But i see that there is not a datatype in sqlserver like
> automatic no. I have to enter id numbers to my tables for each records
> automatically. Would anybody help me about solving this problem? Any
> idea? Thanks

"--CELKO--" <joe.celko@northface.edu> wrote in message
news:a264e7ea.0401132113.38222a3a@posting.google.com...
> >> I have some table fields [sic] which were using automatic number as
> datatype [sic]. <<
>
> You do not understand SQL or data modeling. Fields are not columns;
> tables are not file; rows are not records. The entire concept of a
> physical numbering of rows is not relational. Your original design
> was wrong and you want to copy it into SQL. Why do you want to do
> that again????
>
> Take a course and take the time to learn to do it right.

> Joe, go back in the hole you came from, take an attitude course and then
> come back. Not earlier.

>> Joe on an attitude course? What a waste of time and money! That man