Results 1 to 3 of 3

Thread: SP output parameter nText

  1. #1
    Join Date
    Jun 2005
    Posts
    7

    SP output parameter nText

    Respected Memebers,
    Is it possible to specify nText as the output parameter of an SP.Since the varchar has the limitation of 8000, could anyone suggest an alternative to get rid of the limitation of varchar and send larrge xml strings as output parameter

    I am using SQL Server 2000
    Last edited by geokumpuckal; 06-23-2005 at 05:00 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    TEXT value can be used as a OUT parameter

  3. #3
    Join Date
    Jun 2005
    Posts
    7
    Could you please show a simple example of how to use it and append text values to it if your time permits
    Thanks
    George

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •