SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code | Journey to SQL Authority with Pinal Dave

Very simple and very effective. We use all the time for many reasons - formatting, while creating dynamically generated SQL to separate GO command from other T-SQL, saving some user input text to database etc. DECLARE @strPrint VARCHAR(100); SET @strPrint = 'Example of carriage return'; SET @strPrint = @strPrint + CHAR(13); SET @strPrint = @strPrint… Continue Reading...

Source: SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code | Journey to SQL Authority with Pinal Dave