<div>
doh doh doh.<br />
<br />
Ya know I stared at this wondering what the hell was up. &nbsp;You win the &quot;let me make fun of you by pointing out the obvious&quot; award.<br />
<br />
Thanks much :)
</div>


<div>
&lt;Author Comments&gt;<br />
doh doh doh.<br />
<br />
Ya know I stared at this wondering what the hell was up. You win the &quot;let me make fun of you by pointing out the obvious&quot; award.<br />
&lt;/Author Comments&gt;<br />
<br />
sorry, but that is not obvious &quot;per se&quot;, as it's the typical case of implicit data type conversion, which are difficult to &quot;see&quot;. as from some months/years of experience you remember things like those, and first search in that directly.<br />
<br />
glad I could help to &quot;un&quot;-doe this :)<br />
<br />
Cheers
</div>


<div>
<div class="content wysiwyg-content">
Can someone explain why the following proc is only returning 4000 characters? &nbsp;QA is set to 8192, btw. &nbsp;If I run a len on the retval it returns 4000 characters when there are about 5000 worth of the columns I am returning.<br />
<br />
declare @retval varchar(8000)<br />
&nbsp; &nbsp;select @retval = coalesce(@retval + ',', '') + '[' + column_name + ']' from information_schema.columns<wbr /> where table_name = @table_name and column_name not in (@skipcols) order by column_name<br />
&nbsp; &nbsp;select @retval<br />

</div>
</div>


Can someone explain why the following proc is only returning 4000 characters?  QA is set to 8192, btw.  If I run a len on the retval it returns 4000 characters when there are about 5000 worth of the columns I am returning.

declare @retval varchar(8000)
   select @retval = coalesce(@retval + ',', '') + '[' + column_name + ']' from information_schema.columns where table_name = @table_name and column_name not in (@skipcols) order by column_name
   select @retval


doh doh doh.

Ya know I stared at this wondering what the hell was up.  You win the &quot;let me make fun of you by pointing out the obvious&quot; award.

Thanks much :)

&lt;Author Comments&gt;
doh doh doh.

Ya know I stared at this wondering what the hell was up. You win the &quot;let me make fun of you by pointing out the obvious&quot; award.
&lt;/Author Comments&gt;

sorry, but that is not obvious &quot;per se&quot;, as it&#39;s the typical case of implicit data type conversion, which are difficult to &quot;see&quot;. as from some months/years of experience you remember things like those, and first search in that directly.

glad I could help to &quot;un&quot;-doe this :)

Cheers

Returning varchar(8000) only allowing a return of 4000 characters

Can someone explain why the following proc is only returning 4000 characters?  QA is set to 8192, btw.  If I run a len on the retval it returns 4000 characters when there are about 5000 worth of the columns I am returning.

declare @retval varchar(8000)
   select @retval = coalesce(@retval + &#39;,&#39;, &#39;&#39;) + &#39;[&#39; + column_name + &#39;]&#39; from information_schema.columns where table_name = @table_name and column_name not in (@skipcols) order by column_name
   select @retval


Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.