New line in Sql Query

by

Pinal Dave explains this well in his blog.

http://blog.sqlauthority.com/2009/07/01/sql-server-difference-between-line-feed-n-and-carriage-return-r-t-sql-new-line-char/

DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)
PRINT ('SELECT FirstLine AS FL ' + @NewLineChar + 'SELECT SecondLine AS SL')

More Related Contents:

  1. I need help formatting inner join command in SQL query
  2. Sort by column ASC, but NULL values first?
  3. Search All Fields In All Tables For A Specific Value (Oracle)
  4. Using an Alias column in the where clause in Postgresql
  5. How to get next/previous record in MySQL?
  6. SQL best practice to deal with default sort order
  7. SQL transpose full table
  8. How to Create a real one-to-one relationship in SQL Server
  9. Select statement to find duplicates on certain fields
  10. How to use DISTINCT and ORDER BY in same SELECT statement?
  11. Getting only Month and Year from SQL DATE
  12. How does GROUP BY work?
  13. Linq version of SQL “IN” statement
  14. What is a self join for? (in english)
  15. How to ORDER BY a SUM() in MySQL?
  16. mySQL Returning the top 5 of each category
  17. How to create a PivotTable in Transact/SQL?
  18. Alternate of lead lag function in SQL Server 2008
  19. SQL – Select first 10 rows only?
  20. Generate all combinations in SQL
  21. Postgres Error: More than one row returned by a subquery used as an expression
  22. How to execute an IN lookup in SQL using Golang?
  23. SQL – Inserting a row and returning primary key
  24. How do I start auto increment from a specific point?
  25. How to search SQL column containing JSON array
  26. How to use a dynamic parameter in a IN clause of a JPA named query?
  27. Perform regex (replace) in an SQL query
  28. What is the internal representation of datetime in sql server?
  29. Add a column to existing table and uniquely number them on MS SQL Server
  30. How to execute a stored procedure inside a select query

Leave a Comment