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.
| Author |
Topic |
|
dileck
Starting Member
1 Post |
 Posted - 2004-12-09 : 06:59:32
|
| HiI have an ntext datatype column in one of my tables in SQL Server 2000 db. I need to define this column as a local variable in a stored procedure. But it gives the error "ntext datatype cannot be defined as local variable"how can I declare this?? |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-09 : 07:54:08
|
| Yup, you can't do that I'm afraid. It can be a parmeter to the SProc, but you can basically only insert/update tables with it - not manipulate it.If you need to do string manipulation of a TEXT column you'll have to use the, rather horrible, GetChunk and AppendChunk MethodsKristen |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-09 : 08:32:59
|
| Which, in Transact-SQL, are otherwise known as READTEXT and WRITETEXT. Books Online will tell you more. And no, they DO NOT work on variables, only columns. |
|
|
|
|
|
|
using ntext as local variable