Removing Carriage Return + Line Feed in T-SQL
July 19, 2010 Leave a comment
So annoyed by a CR+LF in XML values within in a table I’m looking at right now. Easily removed with…
REPLACE(REPLACE(XmlField, CHAR(10), ''), CHAR(13), '')
Recent Posts
- Sitecore Analytics Data Loss: Max Size of Insert Queue Reached
- Tracking Selenium Commands Using C# and SQL Server 2008
- Partial Sitecore Cache Clearing by Item
- Abandoning the ASP.NET User Session in Sitecore with OMS
- Running Remote Desktop Console from Command Line
- Troubleshooting SMTP Virtual Server Settings in Windows Server 2008
- Why Can’t I Copy Assemblies from the GAC?
- Sitecore OMS Error: Overwhelming Change Notification
- Getting Started with the Facebook C# SDK
- Integrating Selenium Tests into CruiseControl.Net via NUnit
