SQL Server Strings

How to remove SQL Server line break from text?

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

SQL Server Strings

How to split a delimited text in SQL Server?

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