?
Solved

Multiple line text

Posted on 2007-08-03
1
Medium Priority
?
239 Views
Last Modified: 2010-04-14
Hi Experts

Is it possible to add multiple line text strings to a memo field in a SQL 2000 table using vb.net, like my sample data?

7896535, No 2 Widget, 12, Boxes                  Stackable, 60, 321, 90, 876
7896535, No 1 Widget 1000, 10, Euro Pallets         Stackable, 1200, 600, 1000, 1200

Regards
Joe
0
Comment
Question by:JoeBo747
1 Comment
 
LVL 22

Accepted Solution

by:
dportas earned 2000 total points
ID: 19623499
There is no such thing as a "memo field" in SQL Server. You can insert carriage return and line feed characters into a TEXT, NTEXT, VARCHAR, CHAR, NVARCHAR or NCHAR column in just the same way as any other character. Just pass the appropriate string as a parameter to your INSERT statement or stored procedure.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question