Writing file from SP with text column

pablo.erba

Hi Everyone, I´m new to this group, I´m trying to write a text files
adding content from a text column (more than 8000 characters), I found
code how to write files and it works but i have the problem when added
the text column to the body of the file.

any idea? tip?

thanks in advance!

Pablo.

Dec 21 '06 #1

Subscribe Post Reply

1558

Erland Sommarskog

pa********@gmail.com (pa********@gmail.com) writes:

Hi Everyone, I´m new to this group, I´m trying to write a text files
adding content from a text column (more than 8000 characters), I found
code how to write files and it works but i have the problem when added
the text column to the body of the file.

With what are you writing that file? That is, which programming langauge?
And which client API are you using?

And what problem do you get?

I'm sorry for only asking questions, but I need to know more what you are
doing to be able to help you.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Dec 21 '06 #2

Similar topics

Retaining a Comma when writing to a CSV

by: Deepa | last post by:

I am writing a console app in c# wherein am converting a dataset into a CSV file. It works fine. But I have some values in the dataset which have a comma within(eg. A,B,C). When I view the CSV file...

.NET Framework

Reading and Writing XML from a Dataset with Binary Data

by: Simon | last post by:

Hi all, I have a process, where I take a dataset from an SQL call, and need to write an XML file from that dataset. The data set can contain 10's of tables, each with 100's of rows, and I have...

.NET Framework

Writing multiple queries to a file with BCP

by: caro | last post by:

Hi I am trying to write two Select * statements to the same text file using bcp (from a stored procedure). But cannot find a way of appending to a file using bcp. Does anyone know if this...

Microsoft SQL Server

Reading excel file and writing to access table

by: Paul | last post by:

I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...

Microsoft Access / VBA

Writing to text file

by: Yunus's Group | last post by:

Yunus's Group May 23, 3:36 pm show options Newsgroups: microsoft.public.dotnet.languages.vb From: "Yunus's Group" <yunusasm...@gmail.com> - Find messages by this author Date: 23 May 2005...

Visual Basic .NET

problem reading/writing structures from and to files

by: arne.muller | last post by:

Hello, I've come across some problems reading strucutres from binary files. Basically I've some strutures typedef struct { int i; double x; int n; double *mz;

C / C++

Writing Data In Tabular format in Text File.

by: lucky | last post by:

Hi guys, i want to write some data in tabular format in text file. i've data in strings and i want to write like this in file col1 col2 col3 d1 d1 d1 d2 d2 ...

.NET Framework

ASP.NET 2.0 Reading/Writing to SQL 2000 Text DataType Field

by: ChrisFrohlich | last post by:

ASP.NET 2.0 with Text DataTypes: I've got a similar question going in the SQL group, but I was wondering if anyone has successfully implemented reading/writing character data from a Text datatype...

ASP.NET

118

Help writing SQL statement in PHP script

by: Chuck Cheeze | last post by:

This might be in the wrong group, but... Here is an example of my data: entry_id cat_id 1 20 2 25 3 30 4 25 5 35

PHP

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware