Data Import from Access

Hi,
Recently we upgraded from an Access database to a SQL
Server 2000 database. Everything imported fine. However in
our applications, we used to use an auto number field
which was automatically incremented by Access. After
import into SQL Server, the field with Autonumber got
imported as "int". Because of this none of our
applications seem to be able to work without changing the
Autonumber logic.
Is there an equivalent to the Autonumber field of Access
in SQL Server?Hi Peter,
Thanks for Ryan's help. I agree with him. Also, I'm including some
supplemental information below:
IDENTITY (Property)
Creates an identity column in a table. This property is used with the
CREATE TABLE and ALTER TABLE Transact-SQL statements.
Syntax
IDENTITY [ ( seed , increment ) ]
Arguments
seed
Is the value that is used for the very first row loaded into the table.
increment
Is the incremental value that is added to the identity value of the
previous row that was loaded.
You must specify both the seed and increment or neither. If neither is
specified, the default is (1,1).
For additional information regarding this issue please refer to the
following article below:
Topic: "IDENTITY (Property)"
Please feel free to let me know if this solves your problem or if you would
like further assistance.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.