Hi I am trying to create a table in sql server 2000 and seem to be getting an errorthe code that i am using is as folows:CREATE TABLE Invoice( InvoiceID INT IDENTITY PRIMARY KEY NOT NULL Auto_Increment, Invoice_no VARCHAR(50), RefText VARCHAR(50), CustomerDetails text,)
I want to be able to have the invoiceid as the primary key that auto increments...After creating the table id like to import a csv file with only the following dataInvoice_no, RefText, CustomerDetailsis it possible to do this as i want the id to automatically be generated to be uniquethanks