Microsoft KB Archive/94895

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1587 (4.2)

SYMPTOMS
Under SQL Server 4.2 and 4.2a, attempting to concatenate over 333 strings in a TRANSACT-SQL statement will cause the SQL Server to stack fault. This behavior is independent of the length of the strings being concatenated.

WORKAROUND
Systems requiring a large number of string concatenations should structure their queries to either to create a number of intermediate VARCHAR( 255 ) columns and then concatenate these fields, or to perform string concatenation at the front end.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 4.2a for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
 * }

-

Last reviewed: April 28, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.