Incorrect syntax in examples for selective XML indexes by Erland Sommarskog

Resolved

as Fixed

Type:	Bug
ID:	778831
Opened:	2/8/2013 7:28:07 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

In the topic for CREATE SELECTIVE XML index and related topic there are syntax errors in the FOR clause in the examples (comma missing on two lines).

Details (expand)

English

SQL Server 2012 SP1

Documentation

Not Applicable

http://technet.microsoft.com/en-us/library/jj670104.aspx

FOR(
    pathab = '/a/b' as XQUERY 'node()'
    pathabc = '/a/b/c' as XQUERY 'xs:double',
    pathdtext = '/a/b/d/text()' as XQUERY 'xs:string' MAXLENGTH(200) SINGLETON
    pathabe = '/a/b/e' as SQL NVARCHAR(100)
)

FOR(
    pathab = '/a/b' as XQUERY 'node()',
    pathabc = '/a/b/c' as XQUERY 'xs:double',
    pathdtext = '/a/b/d/text()' as XQUERY 'xs:string' MAXLENGTH(200) SINGLETON,
    pathabe = '/a/b/e' as SQL NVARCHAR(100)
)

0 attachments

Posted by Microsoft on 3/25/2013 at 1:56 PM

The content has been fixed. Thank you for your feedback.

Posted by Microsoft on 2/25/2013 at 1:17 PM

Thank you for your feedback. We are in the process of correcting this topic.

Microsoft