Viewing 14 posts - 1 through 14 (of 14 total)
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...
February 27, 2002 at 3:06 pm
Use the covert command and a style of 1
eg.
CONVERT (CHAR(15),variable_name, 1)
William H. Hoover
Louisville, Ky
February 19, 2002 at 1:27 pm
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...
February 18, 2002 at 12:53 pm
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...
February 15, 2002 at 1:45 pm
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...
February 15, 2002 at 11:06 am
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...
February 13, 2002 at 3:03 pm
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...
January 29, 2002 at 3:06 pm
January 25, 2002 at 8:06 am
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...
January 24, 2002 at 2:44 pm
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...
January 16, 2002 at 1:07 pm
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...
January 14, 2002 at 10:29 am
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...
January 10, 2002 at 12:37 pm
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...
January 10, 2002 at 11:04 am
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...
January 7, 2002 at 11:50 am
Viewing 14 posts - 1 through 14 (of 14 total)