Re: Create Procedure Output ntext

(rey@xxxxxxxxxx) writes:
>
> thanks for your answer.
> With exec(@return+@onelevel) I try to fill my @return variable with
> the content of @onelevel. I can't do it with set @return=@onelevel
> because @return is of type ntext.
>
> How can I do it else?

You can't. Since you are in a dead end, I suggest that you explain
your underlying business problem that you are trying to solve. What
does the calling side of this look like?

I can offer one workaround: move to SQL 2005, which offers the
new datatype nvarchar(MAX), which in difference to ntext is a first
class citizen.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

.

Relevant Pages

  • Re: Applying tranaction log to old data file
    ... "Erland Sommarskog" wrote in message ... Should I restore old backup, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Interesting observation: new SQL time machine! :)
    ... "Erland Sommarskog" wrote in message ... Bob doesn't specifically mention SYSDATETIME, but presumably this function relies on the system time as well. ... "Expert SQL Server 2008 Encryption" ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2000 Assertion recbase.cpp:1378
    ... PSS sounds like the right thing to do: ... "Erland Sommarskog" wrote in message ... >> SQL Server Assertion: File: ... > Erland Sommarskog, SQL Server MVP, sommar@algonet.se> ...
    (microsoft.public.sqlserver.clients)
  • Re: Cannot fetch a row from OLE DB provider "BULK" for linked serv
    ... I understand this is more than a mouthful right now, but SQL Server MVP ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Memory usagePerformance problem
    ... my query executes in seconds. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)