I have a table that has a unique primary key. When I do a BULK INSERT from a text file if an identical row/primary key is found the INSERT errors out and nothing gets added. I need to just skip that row from the text file and keep on trucking. Does anyone have an idea?
BULK INSERT Property...
I am having difficulties in trying to add a comma behind a 6 digit number at the front of every line in a text file. Does anyone know of a good way to do it?
394923 3517 Redman Hall Rd, Pinson, AL Photo Added $28,900
394212 828 49th St, Birmingham, AL Price Changed $17,610
395814 818 85th...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.