Multiple line text

Posted on 2007-08-03
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, 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

Question by:JoeBo747
    1 Comment
    LVL 22

    Accepted Solution

    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.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now