Importing data into SQL2008. It’s a fairly common task, don’t you think? I have done this many times before, though I’ve only imported data into this version a handful of times.
This time was different. I ran into an interesting issue.
I had one column I was importing into a VARCHAR(20) field. The column was populated with half numberic, half alpha-numeric data. Continue reading