SQL Server Performance

accessing text column in sp?

Discussion in 'General Developer Questions' started by limbt, Mar 13, 2004.

  1. limbt New Member

    Hi,

    I have created a stored procedure which accepts an input parameter of text data type.
    I need to manipulate this data by performing string concatenation but i cant assign the text parameter to a local variable as a local variable doesnt support text data type.

    i cant assign the text parameter to a varchar data type as it;s too hugh.

    any workaround on this?

    Regards,
    Boon Tiong
  2. FrankKalis Moderator

  3. satya Moderator

Share This Page