Always remember that programming is a service organization function. If you make software your customers do not use, you will not be a programmer long.

KISS is real (Keep it...

Use the covert command and a style of 1

eg.

CONVERT (CHAR(15),variable_name, 1)

William H. Hoover

Louisville, Ky

sweeper_bill@yahoo.com

The rules when the first relational dbs came out was to use the underscore to separate words, making the columns and tables much more meaningful. The other thing that...

I think this would be a great thing, but then I remember this site is FREE. The way it usually works is that you select a language and a...

I agree a good test plan and trying to break the system in test is vital. There is an old saying amoung programmers that you can make something fool...

It's funny, people in the IT or CS cirriculm in college don't do much with databases, however, I have a BS in Business Administration and was required to take...

Here is one I haven' read here but myself, and several of my friends are going this route. I started out programming on the mainframe MVS. My first...

Sorry the Q number is Q303515. Thanks

William H. Hoover

Louisville, Ky

sweeper_bill@yahoo.com

fyi... I finally found this at http://www.microsoft.com. When the last field in a file is bypassed, (sqlcol = 0) and the last character in that field is equal...

I found that the reason I was only loading one record was the \r\n terminator I typed as /r/n.

I also found that I got the unidentifed format file version was...

The problem with what I was doing is that the extention on the datafile coming from the ftp command was DAT. The Text file attribute wasn't set. It...

Hi Steve,

I can not load a single record, it gives me the error right off. I saved the bcp error file (-e option) and it comes up...

Steve,

I can open the file from notepad, it is on my C: drive of my workstation. I do not know if when running bcp, the ODBC connection...

Yes, Thanks to all, I have that information, my question is does it matter what columns these fields go into. Can I create a BCP format file without running...