Increase size in HTML output in SQL

Question

I am trying to convert the SQL result to HTML format. But the result only gives first 66 rows out of 17266. Can you please let me know what I missed.

declare @query nvarchar(max) 
set @query = N'<h1>BACKUP DATE</h1>'+  N'<style type=''text/css''>'+  N'table td,table th,table caption'+ N'table th{ background-color:3399FF;font-weight:bold; }'+  N'table caption { font-weight;bold;background-color:white; }'+  N'</style>'+  N'<table>'+  N'<caption>BDATE</caption>'+  N'<tr><th>DBNAME</th> <th>FDATE</th></tr>'+ cast(( SELECT td=NAME ,'',td=FDATE FROM TEMP  for xml path('tr'),type) as nvarchar(max)) +N'</table>'  select @query

@vijay,you should explain lil more on what you are trying to do.show some sample etc.anyway may be you should break your sql in several part and store each of them in varchar(max) then lastly combine them. — KumarHarsh, Feb 28 '14 at 07:24
@SatheeshVariath I am using NVARCHAR(MAX) only. however the result displays only 8kb max. — vijay kumar, Feb 28 '14 at 07:28
@NickyvV I tried to add the query along with my question But couldn't, got some message from stack overflow.. Don't know how u added :p — vijay kumar, Feb 28 '14 at 09:31

score 0 · Answer 1 · edited May 23 '17 at 12:03

0

Here is a similar link, maybe you have not declared the output as nvarchar(max)?

Convert a SQL query result table to an HTML table for email

edited May 23 '17 at 12:03

Community

1
1

answered Feb 28 '14 at 07:24

Satheesh Variath

680
4
10

Increase size in HTML output in SQL

1 Answers1