relyky · December 23, 2015 09:23
diff --git a/add_new_line.sql b/add_new_line.sql
 --
 -- new line : 
 --    \r CHAR(13) 
 --    \n CHAR(10)
 --

 DECLARE @MEMO NVARCHAR(MAX);

 SET @MEMO = N'line 1 line 1 line 1 '
 PRINT @MEMO

 SET @MEMO = @MEMO + CHAR(13) + CHAR(10) + N'new line new line new line '
 PRINT @MEMO
	--
	-- new line :
	-- \r CHAR(13)
	-- \n CHAR(10)
	--

	DECLARE @MEMO NVARCHAR(MAX);

	SET @MEMO = N'line 1 line 1 line 1 '
	PRINT @MEMO

	SET @MEMO = @MEMO + CHAR(13) + CHAR(10) + N'new line new line new line '
	PRINT @MEMO
No results found