0

i have created an sql job for sending mails daily.. i am using HTML table for the report to display. and everything is working fine..if the data exceeds 8000 characters my table is getting truncated.. i tried nvarchar(max) still the table is getting truncated..

how to solve this issue..plz help me out

can i save the result in an excel sheet and attach the same in the mail so that i can overcome the word limit problm.. could you help me out to give some sample codes to how to save the result in an excel sheet and attach the same xcel sheet...

thnx navin

navbingo
  • 223
  • 1
  • 6
  • 24

1 Answers1

0

Even if the target column is (max), the expression you are assigning to the column will be 8000 max. See my answer here for a worked example

Community
  • 1
  • 1
gbn
  • 422,506
  • 82
  • 585
  • 676