Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Uploading files to a Web Server using FTP
sodakotahusker, could i please get a copy of your source code. Thanks Stu Mac tek-tips@stumac.f9.co.uk ::-)- gunnermac
- Post #32
- Forum: Visual Basic (Classic)
-
DTS truncates text field
Can anybody tell me how i can stop a DTS package from truncating a text field. I can't find anywhere in the SQL 7 server set-up to change the option of the max length field. ? Stu- gunnermac
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Don't want Carriage Return outputting
Hi, Been working on Oracle for a while now and just swapped to SQL server, so excusde me for being dumb. I have a comments field in my db which contains comma's, carriage returns, etc. I can deal with the comma's by Double Quoting the field, but the carriage return still affects my output...- gunnermac
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Date formatting
Thanks for your replies. I have found the problem. I started by trying the TRUNC command using MSQuery. It seems there is a limitation to the TRUNC command and it still displays the time stamp. I have tried it in PL/SQL and it worked fine. Looks like Microsoft have strayed from the... -
Date formatting
Hi All, I am fairly new to SQL and I have been looking around for a few days to find out the way to format a date in Oracle. I don't want the time stamp to display and have tried using the: to_char(fieldname,'DD-MON-YYYY') command, but then the sort on this field is alphabetical. Could...
