Hasn't yet, Serqiy...

Heh... Pele, huh?

Anyway, I agree... if you are in control of the source of the data, then "store all parts of names in databases separately".  However, the story changes a...

They don't have a switch for it so....

bcp "SELECT 'Pub_ID','Pub_Name','City','State','Country' UNION ALL SELECT * FROM Pubs..Publishers" queryout publ_out /c /t , /r \n /Sservername /Uloginname /Ppassword

You could do...

The free trial version would certainly work but... why don't you spend the $64 for the Developer's version so you don't have to worry?  And, why doesn't Borland Interbase support...

Then, don't add columns to an existing table... make a new table that has all of the necessary columns (I'm thinking temp table here) and copy the data from the...

>>After you finish with it start with his original name: "Jean-Claude Camille François Van Varenberg"

Leave it to Serqiy to know something like that

Temp tables do NOT always write to disk if they are small... do see Q4of the following URL which I've now posted 3 times in this thread...

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

... which...

Oh, no, no, no.... don't use BETWEEN... it's a form of "Death by SQL".   First, 23:59:59.999 will be rounded up to the next day and you will get all of the...

Praveen,

I've been asked many times to improve the performance of "a server"...

Yeah, overall server tuning and correctly adding appropriate indexes and deleting unused...

BULK INSERT can also use a format file for complex imports.  For simple imports that all use the same column delimiter, you don't even need that... Bulk Insert is a...

You could also do it using the other way found on the same web site you posted...

http://www.motobit.com/tips/detpg_read-write-sql-image-file/

It's still a bad idea to save images in a table, though...

First of all, the normal soap box diatribe about all the problems associated with saving images in a table would apply here.  It was a bad idea.

On to the problem......

I agree with the others.... the "quick fix" would be to convince folks that an IDENTITY column is the only way to go.

And, just to give you the warm fuzzies......

I think that someone was barking up the wrong tree when they wrote the requirement ... but, since some folks suggested doing it...

Only if I absolutely had to put up with the same cruddy requirement that William has obviously been blessed with.   It's simple data...