SQL Server Strings

SQL Server strings

SQL Server Strings

How to remove SQL Server line break from a text?

June 13, 2017

How to remove SQL Server line break from a 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 …

SQL Server Strings

Split a delimited text with SQL Server

May 31, 2017

How to split a delimited text in SQL Server? 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 character …