Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How can I convert an nText to something else?

Author  Topic 

laugedyret
Starting Member

3 Posts

Posted - 2001-07-09 : 08:35:03
Hi,

How can I convert an nText to something else?

I have an Stored Procedures where I have to OUTPUT an nText DataType.

But my Query analyser want me to convert the nText til something else. But to what??

Pleace give me an full exampel like this, where I do it whit an int.

Ex:

In the Stored Procedures:

@Date int OUTPUT

Select @Date = Date from tblDate where Date = @ToDay



And in my ASP site, I do this:

.Parameters.Append .CreateParameter ("@Date", adInteger, adParamOutput)


I hope U can help me :-)



   

- Advertisement -