Function - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Function

Author

Topic

jhunu
Starting Member

18 Posts

Posted - 2011-12-13 : 12:55:49

In THE query , i have to insert a Enter key. Do we have any function for that

pnash
Starting Member

26 Posts

Posted - 2011-12-13 : 13:01:03

in output formatting if you want print something to in new line then you can use + char(13)

sunnyleoneo
Starting Member

19 Posts

Posted - 2011-12-13 : 14:34:23

Hi,

Check this short and sweet blog this will definitely help you
T-SQL Script to Insert Carriage Return and New Line Feed in Code
http://blog.sqlauthority.com/2007/08/22/sql-server-t-sql-script-to-insert-carriage-return-and-new-line-feed-in-code/

Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
http://blog.sqlauthority.com/2009/07/01/sql-server-difference-between-line-feed-n-and-carriage-return-r-t-sql-new-line-char/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources