Microsoft KB Archive/156945

= BUG: Text And Image Can Be Parameters for Stored Procedures =

Article ID: 156945

Article Last Modified on 3/1/2005

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q156945



BUG #:15966 (NT: 6.50) 15643 (6.00)



SYMPTOMS
The documentation for SQL Server 6.0 and 6.5 incorrectly states that you cannot use either text or image parameters for stored procedures. The SQL Server "Transact-SQL Reference" has references to datatypes on pages 53, 118, and 176. The SQL Server "Database Developer's Companion" has references to datatypes on page 201. On all of these pages, the documentation incorrectly states that text and image datatypes cannot be used for parameters.

The image and text datatypes have been available for use as parameters in stored procedures since Microsoft SQL Server version 6.0. However, image and text datatypes still cannot be used as local variables.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft SQL Server version 6.0 and 6.5 documentation. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: wrong incorrect erroneously erroneous

Keywords: kbbug KB156945

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.