Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    3

    Unanswered: how to store large data in sql variable

    in my store procedure i have a varchar(max) variable and after some calculations i store all data in it and i want to email data to users. some problem is that data is too large to store in varchar(max) so not all data store in variable, when variable is fill, all remaining data is lost, please tell me how to do that things

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you post the exact code please?

    What are you using to send the email - chances are the parameter there will have a character limit.
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    varchar(max) is 2gb in size, is your data more than that?

  4. #4
    Join Date
    Jun 2009
    Posts
    3
    thanks for your reply.
    my problem is solved

  5. #5
    Join Date
    Jun 2009
    Posts
    3
    thanks for your reply.
    my problem is solved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •