Sql Error #7002, Severity 16

Sql Error Number:7002
Severity: 16

Description: OPENXML XPath must be of a string data type, such as nvarchar.

Possibly related links:

Errors 7000 - 7999
OPENXML document handle parameter must be of data type int. 7001. 16 ... OPENXML XPath must be of a string data type, such as nvarchar. 7003. 16 ...

Errors 7000 - 7999
OPENXML document handle parameter must be of data type int. 7001. 16. No ... OPENXML XPath must be of a string data type, such as nvarchar. 7003. 16. No ...

XML Support in Microsoft SQL Server 2005
XML data type methods must be provided within a user-defined function, for which ... The SQL type nvarchar(max) of the result is specified as the second argument of ...

XML in Yukon: New Version Showcases Native XML Type and Advanced Data ...
... XPath 2.0 models allow the concrete data to be exposed as a series of ... query engine must start with the premise that every piece of data is a string ...

Performance Optimizations for the XML Data Type in SQL Server 2005
... with a string value, a conversion to XML data type occurs ... http://msdn.microsoft.com/sql/ MSDN Library. Servers and Enterprise Development. SQL Server ...

Using OPENXML
The XPath pattern specified as ColPattern can also be specified to map the XML ... clause, a column pattern that is mapped to the xml data type column, whether ...

Data Points: XML Features in SQL Server 2000
... can pass in the XML as a variable of any string type (such as VARCHAR(8000) or ... the OPENXML function can filter out rows, only a single XML document must be ...

Retrieving Unconsumed Data by Using the sql:overflow-field
... attribute name="ContactName" type="xsd:string" />

Retrieving Unconsumed Data Using the sql:overflow-field (SQLXML 4.0)
When records are inserted in a database from an XML document by using the Transact-SQL OPENXML function, all the unconsumed data from the source XML document can be ...

XML Best Practices for Microsoft SQL Server 2005
For more information, see http://msdn.microsoft.com/SQLXML. ... converting a string type to XML data type, SQL ... Example: Use of OpenXml() on XML Data Type ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!