var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: import data and get unique id
I am trying to import a text file and have sql give it a unique id number but it keeps saying that the id field cannot have null values. What do I need to do to get this to work?
So the table you are importing to does it have a column defined with IDENTITY property? What are you using to import DTS, BCP, BULK INSERT?
I am using DTS and the table does have a identity field.
Well that is what you will have to do first. Create your table with a column having the property of IDENTITY.
See Books online for more info.
CREATE TABLE new_employees
id_num int IDENTITY(1,1),
fname varchar (20),
I did that but I still get an error saying that column cannot contain a null value when I import the data for the other column out of a text file (csv).
I can offer a different perspective,
You just have to disable the 'enable identity insert' checkbox when you are doing your import.
That worked perfectly, Thank you so much.