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

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

X-Received	by 2002:a05:622a:60b:b0:31d:4455:c630 with SMTP id z11-20020a05622a060b00b0031d4455c630mr7459786qta.216.1656940427762; Mon, 04 Jul 2022 06:13:47 -0700 (PDT)
X-Received	by 2002:a05:6808:357:b0:335:3785:5210 with SMTP id j23-20020a056808035700b0033537855210mr17374013oie.87.1656940427478; Mon, 04 Jul 2022 06:13:47 -0700 (PDT)
Path	csiph.com!1.us.feeder.erje.net!feeder.erje.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.programming
Date	Mon, 4 Jul 2022 06:13:47 -0700 (PDT)
In-Reply-To	<#nIsLyZ6BHA.2172@tkmsftngp04>
Injection-Info	google-groups.googlegroups.com; posting-host=93.46.182.156; posting-account=CuWlPAoAAAA9h0T_uXei1vFR1MK32h4P
NNTP-Posting-Host	93.46.182.156
References	<u2oJJbw1BHA.1976@tkmsftngp03> <sCX2z5n2BHA.2440@cpmsftngxa07> <#nIsLyZ6BHA.2172@tkmsftngp04>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<93593b89-6429-4af3-8f56-3fabea17045cn@googlegroups.com> (permalink)
Subject	Re: The text, ntext, and image data types are invalid for local variables
From	Denis <korolidenis@gmail.com>
Injection-Date	Mon, 04 Jul 2022 13:13:47 +0000
Content-Type	text/plain; charset="UTF-8"
Content-Transfer-Encoding	quoted-printable
Lines	66
Xref	csiph.com microsoft.public.sqlserver.programming:31378

Show key headers only | 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