Friday, January 30, 2009

SQL Server 2008

How to add a new line character inside a SQL query statement :
char(13)+char(10)+REPLICATE (' ', x), where x stands for the number of spaces we want to add. So if we wanted to add 10 spaces we would use :

char(13)+char(10)+REPLICATE (' ', 10)