Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.programming > #31379

Re: The text, ntext, and image data types are invalid for local variables

Show all headers | View raw

Denis (korolidenis@gmail.com) writes:
> Il giorno lunedì 22 aprile 2002 alle 03:25:51 UTC+2 Thorir Danielsson ha
> scritto: 
>> The problem is that we have to move 'image' data from one table to
>> another. When we try to use a cursor and read the data into variable
>> the error appears. If anyone knows another way to move 'image' data
>> between tables then please reply 
>
> did you guys figure it out in the end?
> 

I guess they did. Way back in 2002, this was a difficult problem with
no good workaround. But starting with SQL 2005, the types text, ntext
and image are deprecated, and you should use varchar/nvarchar/varbinary(MAX) 
instead. They are first-class citizens, and you can say:

DECLARE @x varbinary(MAX)

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Find similar

Thread

Re: The text, ntext, and image data types are invalid for local variables Denis <korolidenis@gmail.com> - 2022-07-04 06:13 -0700
  Re: The text, ntext, and image data types are invalid for local variables Erland Sommarskog <esquel@sommarskog.se> - 2022-07-05 09:48 +0200

csiph-web