Blog Script Nuances

Categories: Blogging
Tags:
Comments: No Comments
Published on: April 30, 2010

I recently ran across an issue that is really annoying. I use a plugin to display my TSQL scripts in the original formatting. Unfortunately it does not maintain that original formatting in all areas.

The specific case I ran into deals with the word “TEXT.” When using that word as a part of a FOR XML Path statement, it gets upper cased. Upper case version of text is not a valid command for the FOR XML Path statement. It will cause an error. The code still showed it as lower case when I went to edit it, but the display of the code was what was changed.

The only workaround is to leave a note stating that it should be LCASE instead of UCASE.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *










Calendar
April 2010
M T W T F S S
« Mar   May »
 1234
567891011
12131415161718
19202122232425
2627282930  
Content
SQLHelp

SQLHelp


Welcome , today is Monday, June 26, 2017