Index counter

[wallaceoc80]

I am importing data from a MS Access database into a SQL Server database. In the MS Access db I have a table called FAQ that has a FAQID column which is an auto increment number that increments by 1 every time a new row is entered into the table.

Is it possible to do the same type thing with SQL Server? In my SQL Server table I again have an FAQ table with FAQID as the primary key. It is this FAQID column that I want to increment by 1 every time a new row is created.

Regards,

Wallace

 

[despierto]

Look into identity fields, with INCREMENT(1,1). Same thing as autonumber.