Dynamic SQL > 8000 characters

• Shalin Kapadia

  SSC-Addicted

  Points: 490

  More actions

  October 15, 2008 at 10:12 pm

  #72080

  Hi all,

  Is there any way to execute a dynamic sql statement > 8000 chars in SQL Server 2000.

  I am building the sql command based on the rows of a table.

  Any help would be appreciated.

  Thanks,

  Shalin

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  October 15, 2008 at 11:09 pm

  #885635

  EXEC (@SQL1 + @SQL2 + SQL3 + ...)

  _____________
  Code for TallyGenerator