My daily life, technical articles

Allen Kan

Home

Posts Tagged MSSQL

MS SQL Replace Line Break

Posted by allenkwc in Database on April 10, 2017

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')

- Blogroll
Archives
- October 2017 (2)
- June 2017 (1)
- April 2017 (2)
- March 2017 (1)
- August 2016 (1)
- November 2015 (2)
- September 2015 (3)
- August 2015 (1)
- June 2015 (1)
- January 2015 (1)
- November 2014 (1)
- October 2014 (1)
- August 2014 (2)
- July 2014 (1)
- June 2014 (1)
- May 2014 (7)
- October 2013 (1)
- August 2013 (1)
- July 2013 (2)
- May 2013 (2)
- December 2012 (2)
- November 2012 (1)
- October 2012 (1)
- August 2012 (4)
- July 2012 (6)
- June 2012 (1)
- May 2012 (2)
- April 2012 (1)
- March 2012 (1)
- February 2012 (3)
- January 2012 (3)
- December 2011 (2)
- November 2011 (3)
- October 2011 (1)
- September 2011 (1)
- July 2011 (1)
- June 2011 (4)
- May 2011 (8)
- April 2011 (10)
- March 2011 (10)
- February 2011 (11)
- December 2010 (4)
- November 2010 (5)
- October 2010 (6)
- September 2010 (4)
- August 2010 (7)
- July 2010 (3)
- June 2010 (3)
- May 2010 (3)
- April 2010 (4)
- March 2010 (3)
- February 2010 (2)
- January 2010 (1)
- December 2009 (7)
- November 2009 (7)
- October 2009 (4)
- August 2009 (6)
- July 2009 (8)
- June 2009 (13)
- May 2009 (6)
- April 2009 (12)
- March 2009 (6)
- February 2009 (4)
- January 2009 (5)
- December 2008 (12)
- November 2008 (18)
- October 2008 (8)
- September 2008 (5)
- August 2008 (18)
- July 2008 (4)
- June 2008 (4)
- May 2008 (1)
- March 2008 (3)
- February 2008 (1)
Meta
- Log in
- Valid XHTML
- XFN
- WordPress

Fusion theme by digitalnature | powered by WordPress
Entries (RSS) and Comments (RSS) ^

SetTextSize SetPageWidth