SQL servicer script, data type for MEMO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL servicer script, data type for MEMO

Hybrid View

  1. #1
    DH Guest

    SQL servicer script, data type for MEMO


    Hello All:

    I am working on a VB(6.0) project which load data into a SQL Server (7.0)
    database. I wrote a SQL script to Create_Table on the database. What data
    type I can use for a "memo" field on a table? I used verchar (255) but it
    was too small to hold data on the field.

    Thanks in advance,

    DH




  2. #2
    Join Date
    Aug 2007
    Posts
    2

    Thumbs up Equivalent Datatype of MEMO in SQL Server 2000

    Hi !!!!

    The Equivalent data type in SQL Server 2000 is NTEXt.

    Size of varchar can go upto 8000 so you can always use varchar(8000).

    Problem with using NText and TExt is that while one cannot use it relational operators with it.....

  3. #3
    Join Date
    Aug 2007
    Posts
    2

    Thumbs up Equivalent Datatype of MEMO in SQL Server 2000

    Hi !!!!

    The Equivalent data type in SQL Server 2000 is NTEXt.

    Size of varchar can go upto 8000 so you can always use varchar(8000).

    Problem with using NText and TExt is that while one cannot use it relational operators with it.....

    go through this website

    http://www.microsoft.com/technet/pro...rt2/c0561.mspx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center