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

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

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

Show all headers | View raw

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
> Thorir.
> "Hari Ramachandran [MS]" <ha...@online.microsoft.com> wrote in message
> news:sCX2z5n2BHA.2440@cpmsftngxa07...
> >
> > Local variables cannot be of text, ntext, or image data type.
> > See Books-on-line topic: DECLARE @local_variable (T-SQL)
> >
> > Hope this helps.
> >
> > Hari Ramachandran
> >
> > Please reply only to newsgroups. When posting, please state the version of
> > SQL Server being used (using select @@version) and the error number/exact
> > error message text received, if any.
> >
> > Disclaimer:
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > --------------------
> > | From: "Gunnar Stefánsson" <gun...@ru.is>
> > | Subject: The text, ntext, and image data types are invalid for local
> > variables
> > | Date: Fri, 29 Mar 2002 09:48:31 -0000
> > | Lines: 12
> > | X-Priority: 3
> > | X-MSMail-Priority: Normal
> > | X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
> > | Message-ID: <u2oJJbw1BHA.1976@tkmsftngp03>
> > | Newsgroups:
> >
> microsoft.public.access.adp.sqlserver,microsoft.public.sqlserver.programming
> > | NNTP-Posting-Host: addi.spar.is 193.4.44.40
> > | Path: cpmsftngxa07!tkmsftngp01!tkmsftngp03
> > | Xref: cpmsftngxa07 microsoft.public.sqlserver.programming:245635
> > microsoft.public.access.adp.sqlserver:5459
> > | X-Tomcat-NG: microsoft.public.sqlserver.programming
> > |
> > | Server: Msg 2739, Level 16, State 1, Procedure sp_createunits, Line 0
> > | The text, ntext, and image data types are invalid for local variables.
> > |
> > | Also i need to create a BLOB field
> > |
> > | Anyone
> > |
> > | Thanks
> > | Gunnar Stefánsson gun...@ru.is
> > |
> > |
> > |
> > |
> >
did you guys figure it out in the end?

Back to microsoft.public.sqlserver.programming | Previous | Next — Next 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