hi all,
i m doing database migration from Ms Access to SQL Server 2000.but there is a field of a table in Ms Access that i use autonum. when i do import data in SQL Server that field become int in SQL Server.
now i want to change to some sort of autonum in sql server but i couldn't find it. wat else data type i can use to hav auto increment feature?is it available in sql server?
create table a (ii int identity(1,1))
When you are transferring the data from access to SQL Server you need to use:
SET IDENTITY_INSERT a ON
If you are using DTS in Enterprise Manager, there is a checkbox corresponding to this SET statement.