Home Forums SQL Server 2005 T-SQL (SS2K5) how can i use declare text in sql store procedure RE: how can i use declare text in sql store procedure

  • May 6, 2009 at 5:37 am

    #989438

    Hi,

    text datatype can have maximum length of 8000.

    I think you should break your dynamic query into 2-3 parts.