How can i pass a var type ntext to a sp?

  •  

    I have a sp where inside exists a call a Sp which it  receives like argument a variable of type ntext well for my surprise i cant declare variable of type ntext like local

    example

    create proc sp_my @a

    as

    begin

    exec SP_ntext @ntext

     

    end

    is impossible to pass a ntext? only can i pass a nvarchar???

     

  • Since this posted in SQL Server 2005, why not use nvarchar(max)? No problems there, stores the same data.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply