text variables?

4 Aug 2006 8:10 AM

Man-wai Chang

I can't do "declare @var text". How could I get around it?

I need to open a cursor to fetch a text from the table into memory....

--
SoftMedia Technology Co., Ltd.
Website: http://www.softmedia.hk Tel: (852)2743 4228
* TryEasy Accounting/POS/Trading/ERP solutions

4 Aug 2006 9:39 AM

Augustin Prasanna

found a similar discussion in another forum.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=26582

Show quote

"Man-wai Chang" wrote:

> I can't do "declare @var text". How could I get around it?
>
> I need to open a cursor to fetch a text from the table into memory....
>
> --
> SoftMedia Technology Co., Ltd.
> Website: http://www.softmedia.hk Tel: (852)2743 4228
> * TryEasy Accounting/POS/Trading/ERP solutions
>

4 Aug 2006 1:27 PM

Man-wai Chang

Augustin Prasanna wrote:

> found a similar discussion in another forum.
>
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=26582

Thanks. I guess I need to approach the problem in another way...

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.6
^ ^ 21:26:01 up 19 days 4:49 1 user load average: 1.02 1.05 1.01
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk