How Char(13) results in a new line in SQL Server?

What is the science behind the char(13) resulting in a new line in SQL server?Always wondered how it works.

2

Best Answer

Too long to comment, just to elaborate a little bit on the comments...

If you look at an ASCII table, you will see the decimal and character values for each. You can check / view these in SQL using the ASCII and CHAR functions.

select ASCII_Decimal_Value = ascii('!'),ASCII_Character = char(33)

The snippet above shows the decimal and character values for an exclamation point. Knowing this, you should understand why 13 and 10 is used for carriage return and new line, respectively, and how to use it. For example... if you run the code below in SSMS with the output as Results to Text, you can see the carriage return.

select 'This will be on the first line' + char(13) + 'and this will be on the second'

13 is ASCII the value of carriage return character.

Random Posts

Static binding and dynamic binding in Javaconsole.log timestamps in ChromeWhat is the meaning of -rc in semantic versioning?Bash coding conventionsFailed to transform jar to match attributes"Insert if not exists" statement in SQLiteWhat is the proper font for printing on thermal paper?How to pass command line arguments to a shell alias? [duplicate]Decorator pattern for model functionality in Rails 5Not allowed to "Create Facebook Page" for appAlternate for Normalizer Transformation?How to make QR Code in crystal reports Visual StudioCreate a share sheet in iOS 15 with swiftUIChanging SAS variable labels/attributes in one dataset based on variables in a separate dataset containing a codebook - PROC SQL? PROC DATASETS?Where do Azure Queue Storage Messages go?How do I use GridLayout and multiple Panels?Any way to stream a map like "(k,v)" instead of working with (entry)?How to stop excel from autoconversionConvert a character digit to the corresponding integer in CHow to simulate a click with JavaScript?