Returning TEXT data in a Stored Procedure

From: Raul Villaronga (rvillaronga_at_pnat.com)
Date: 05/20/04

  • Next message: Nandita Reshamwala: "User defined function" 
    Date: Thu, 20 May 2004 13:01:25 -0700

    I am developing an application that needs to have
    reference to a SQL Server Text data type. I know how to
    use the TEXTPTR() and DATALENGTH() functions but do not
    know how to store the data returned from the READTEXT into
    a variable that can be manipulated, printed, sent to
    another table, etc.

    Any help or direction would be appreciated.

  • Next message: Nandita Reshamwala: "User defined function"

    Relevant Pages

    • Re: Access 97 to SQL
      ... The timestamp is a data type, ... the timestamp field does not need to be part of the SELECT ... > converted the Access tables to a SQL Server 2000 database and linked the ... > the way I set up Autonumbering in SQL? ...
      (microsoft.public.access.externaldata)
    • Re: Data Types
      ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
      (microsoft.public.sqlserver.programming)
    • Re: Recordset Update Error
      ... SQL Server bit fields need to be declared as ... Add a timestamp field to each table. ... The timestamp is a data type, ... 'Opens Recordset ...
      (microsoft.public.access.externaldata)
    • Re: Update string too long?
      ... search through the newsgroups, as wells as google.com for the web. ... Pro SQL Server 2000 Database Design - ... Beginner posts are the most helpful and it is ... what is the data type and length for the ...
      (microsoft.public.sqlserver.programming)
    • Re: Data Types
      ... >> Steve, ... >> Tibor Karaszi, SQL Server MVP ... >>> character varchar data type? ... A uniqueidentifier uses 16 bytes. ...
      (microsoft.public.sqlserver.programming)