How can we help you today? How can we help you today?

SQL Prompt doesn't respect SQL XML DML statements

I use the XML fields in SQL Server 2005 and every now and then I need to use the XML DML statement to modify the XML fields directly.

When trying to enter a statement like:

UPDATE dbo.T_Entry
SET EntryData.modify('insert <IsSMEAdmin>True</IsSMEAdmin> as last into /DomainList[1]/Domain[1]/MailboxList[1]/Mailbox[1]')
WHERE
......

SQL Prompt insists on capitalizing the "AS", "LAST", "INTO" and "MODIFY" keywords, even though they're clearly contained inside a string with the ' ' markers........ please don't ! The SQL XML DML statements are case sensitive and shouldn't be modified !

Cheers
Marc
mscheuner
0

Comments

1 comment

Sort by
  • Eddie D
    Thank you for your post into the forum.

    By default SQL Prompt will 'UPPERCASE' keywords in the manner that you have described.

    To modify this behaviour Open SQL Prompt menu->Options->Inserted Candidates->Select Case from the list in the left hand column->Case: Reserved keywords->Modify the drop down box from 'UPPERCASE' to 'Leave as is'.

    Hopefully this should resolve your problem.

    Many Thanks
    Eddie

    Eddie Davis
    Red Gate Software Ltd
    Technical Support Engineer
    E-Mail: support@red-gate.com
    Eddie D
    0

Add comment

Please sign in to leave a comment.