BUG: Text And Image Can Be Parameters for Stored Procedures (156945)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Minor | Last Reviewed: | 3/1/2005 |
|---|
| Keywords: | kbBug KB156945 |
|---|
|