Use a variable of type nvarchar(8000) or lower length parse the contents into the variable chunks at a time (using cast) and then execute them.

Brian Freeman
(770) 916-0595 ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

viney kumar wrote:
> suppose i have a table name abc
>
> contain one field of type ntext
>
> create table abc (x ntext)
>
> suppose i have one row in this table contain
>
> insert into abc ("insert into x values ('a') insert into x values
> (b)")
>
> i wanted to execute all the insert statemet one bye ...
>
> but it will not allow me to user localvariable that holds text
> datatype
>
> is there anyother way
>
>
>
> regards ,
> Viney
> Adapt-india
>
>
> ___________________________________________________
> Meet your old school or college friends from
> 1 Million + database...
> Click here to reunite www.batchmates.com/rediff.asp
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page