MsSQL Imports

Z

zMaestro

Perch
Hi,
I've a table containing 10,000 records, with stucture containing int [auto increment]

I want to import a 2,000 records from another table which is exactly the same structure, I get this Error:

Cannot inset the value NULL into the column 'ID', column does not allow nulls

How can this be overcame? :)
thanks
 
temporary allow nulls, next import, now run SQL to replace NULL with "" and put the constraint back?
 
You must log in or register to reply here.
Back
Top