SQL Server Strings Archives

August 5, 2020

How to remove SQL Server line breaks from text?

June 13, 2017

How to remove SQL Server line breaks from text? If you store a string as a variable or a column in SQL Server , then it can contain line breaks. For example if you export the string to excel, your line will be cut. Indeed, with SSMS, if you select …

How to split a long SQL Server text into lines?

May 31, 2017

How to split a long SQL Server text into lines? The string to split can have a comma or a semicolon delimiter. Using an SQL Server query, you can cut a string compounded of text delimited by commas, semicolons, tabulations, dash, underscore, or even dots. It can basically be any …