How to correctly insert newline in nvarchar [duplicate]

by

The problem is your setting on SSMS, not that the data doesn’t have a line break.

Go to: Tools -> Options -> Query Results -> SQL Server -> Results to Grid -> Retain CR/LF on copy or Save and make sure the option is ticked.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. get a comma delimited string from rows [duplicate]
  3. Scope of temporary tables in SQL Server
  4. Sequence vs identity
  5. Count Number of Consecutive Occurrence of values in Table
  6. Find min and max for subsets of consecutive rows – gaps and islands
  7. How to get Previous Value for Null Values
  8. SQL Server: +(unary) operator on non-numeric Strings
  9. Get top 1 row of each group
  10. How to calculate age (in years) based on Date of Birth and getDate()
  11. Convert Month Number to Month Name Function in SQL
  12. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  13. Multiple INSERT statements vs. single INSERT with multiple VALUES
  14. Limit on the WHERE col IN (…) condition
  15. Removing leading zeroes from a field in a SQL statement
  16. Generate a resultset of incrementing dates in TSQL
  17. Getting result of dynamic SQL into a variable for sql-server
  18. How to get difference between two rows for a column field?
  19. Better techniques for trimming leading zeros in SQL Server?
  20. Common Table Expression, why semicolon?
  21. T-SQL split string based on delimiter
  22. SQL Server SELECT into existing table
  23. Convert Date format into DD/MMM/YYYY format in SQL Server
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. SQL take just the numeric values from a varchar
  26. SQL Server SELECT INTO @variable?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Select a column if other column is null
  29. How to subtract 30 days from the current date using SQL Server
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment