String > 8000 in Stored Procedure

• Manish Joisar

  Ten Centuries

  Points: 1173

  More actions

  October 13, 2005 at 11:51 pm

  #91769

  I have string which goes beyond 8000 character

  What can i do for it

  I have tried with Seperating Query in Two seperat variable

  But one of Query i am generating in a loop & it is going beyond 8000 character

  I have solved this problem with different logic

  Is any other solution for this problem

  Waiting for reply

  Thanks

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  October 14, 2005 at 6:45 am

  #597328

  Manish - if you search this site you should find several posts with similar issues - here're a few that you could look at..

  8k or bust

  8k characters

  exceeds 8k

  varchar 8k

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**