SQL query SIZE

• Rajitha Aththnayake

  SSC Journeyman

  Points: 92

  More actions

  September 13, 2004 at 5:17 pm

  #66109

  I have a sql query which produces the size more than varchar (8000)/max size. So my stored procedure get crashes. Can any one help me to work around with this problem, I greatly apprecaite it.

   

  DECLARE @sql varchar(8000)   -- The maximum limit of varchar 8000

  //My @sql query goes here

  EXEC (@sql) //crashes

   

   

   

   

• David.Poole

  SSC Guru

  Points: 76145

  More actions

  September 14, 2004 at 1:24 am

  #522887

  DECLARE @sSQLSELECT VARCHAR(8000)

  DECLARE @sSQLFROM VARCHAR(8000)

  DECLARE @sSQLWHERE VARCHAR(8000)

  SET @sSQLSELECT='SELECT .......'

  etc

   

  EXEC( @sSQLSELECT + @sSQLFROM + @sSQLWHERE)

  LinkedIn Profile

• Rajitha Aththnayake

  SSC Journeyman

  Points: 92

  More actions

  September 14, 2004 at 1:39 am

  #522888

  Thanks David. Appreciate.

  raj