"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:uj1KOlEeGHA.3948@TK2MSFTNGP03.phx.gbl...
> Hello there
>
> I need to build T-sql update parse dinamicly which can be more then 8000
> characters.
>
> I can't (as far as i know) use text as varient, i can't concarent another
> text to it, and so on
>
> here is somthing i tried to run:
> create table Test (
> id int identity(1,1) primary key clustered
> , txt text)
>
> insert Test
> VALUES ('Absolute position')
>
> update Test
> SET txt = txt + ', Bandwith'
>
> and got an error:
> Server: Msg 403, Level 16, State 1, Line 1
> Invalid operator for data type. Operator equals add, type equals text.
>
> how can i work with text field?
>
>

> It was good for the first part, to concatent strings to the text, On the
> temp table i also places string for determing the size of the text to make
> it use for the future
>
> now i need to execute the text.
>
> I tried to use Execute but i couldn't. so far i use exec by getting the
> string to varchar(8000) and run it by: exec(@str)
>
> This options cannot be done on text. so how can i execute the data on text
> field?

> This options cannot be done on text. so how can i execute the data on text
> field?

"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:OEjVJvEeGHA.3556@TK2MSFTNGP02.phx.gbl...
> You're going to have to get comfortable with the UPDATETEXT function,
which
> is somewhat painful to work with. Here's a sample from Nigel Rivett:
>
> http://www.nigelrivett.net/SQLTsql/ReplaceText2.html
>
> Note, SQL Server 2005 has a new datatype called VARCHAR(MAX) which makes
all
> of this much easier.
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
>
> "Roy Goldhammer" <roy@hotmail.com> wrote in message
> news:uj1KOlEeGHA.3948@TK2MSFTNGP03.phx.gbl...
> > Hello there
> >
> > I need to build T-sql update parse dinamicly which can be more then 8000
> > characters.
> >
> > I can't (as far as i know) use text as varient, i can't concarent
another
> > text to it, and so on
> >
> > here is somthing i tried to run:
> > create table Test (
> > id int identity(1,1) primary key clustered
> > , txt text)
> >
> > insert Test
> > VALUES ('Absolute position')
> >
> > update Test
> > SET txt = txt + ', Bandwith'
> >
> > and got an error:
> > Server: Msg 403, Level 16, State 1, Line 1
> > Invalid operator for data type. Operator equals add, type equals text.
> >
> > how can i work with text field?
> >
> >
>
>

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:O7CV7dJeGHA.4900@TK2MSFTNGP02.phx.gbl...
> > This options cannot be done on text. so how can i execute the data on
text
> > field?
>
> That depends, do you know how big your string might be? My suggestion
would
> be to break into chunks of 8000 and execute them together using separate
> variables, like Erlan already described.
>
> EXEC(@VariableWithFirst8000Chars + @VariableWithNext8000Chars + /*... + */
> @VariableWithLast8000Chars);
>
> Or, explain the actual problem and we can come up with a better solution.
> The best answer is rarely a temp table and dynamic SQL.
>
>