Results 1 to 2 of 2

Thread: ntext Type !!

  1. #1
    Join Date
    May 2004
    Posts
    15

    Unanswered: ntext Type !!

    Hi ...

    I want define a ntext type variable and set the result of select from ntext field of table in that variable and Execute the variable .

    Forexample :
    Declare @A ntext
    select @A=Fildntext from Table
    set @A=@A+'string'
    sp_executesql @A

    Therefore how can i use ntext type??

    thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You can't use text or ntext as local variables...period. You will need to create a temp table with an ntext field, run your results into that, then select from it.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •