Post reply

How to use a variable with more than 8000 size in a stored procedure in SQL server 2000

  • May 22, 2008 at 5:45 am

    #71601

    Hi,

    I am working on a stored procedure that creates an excel sheet and fills each row with data. Now my requirement is to add a row with much more than 8000 characters in a row. For that I need to have a variable with the length more than 8000. I can't use varchar, as its length is maximum 8000 in SQL server 2000 and I also cant use a variable of type TEXT in a stored procedure. Can anybody help me to know if we have any other way to handle it.

    Thanks & Regards,

    Pavan

  • May 23, 2008 at 4:46 am

    #819583

    Hi,

    Probably the best way is to create temporary table into the stored procedure and when you are writing to Excel file at that time you can say select * from temporary table t.....it will not have limit when you insert data into temp table and read from it..

    regards,

    vijay

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply