Inserting Line break in Store Procedure

• Neetal Shah

  SSC Veteran

  Points: 220

  More actions

  March 10, 2006 at 5:37 am

  #112162

  Hello Friends !!!

  I have created a Store Procedure which is as below

  *-----------------------------------------------------------*

  CREATE PROCEDURE [dbo].[MilestoneAlertMail] AS

  declare @Miledate as datetime

  declare @Projectid as int

  declare @Projectdetid as int

  declare @Body as varchar(8000)

  declare @mailsenton as datetime

  set @Body= 'Alert Mail – I (MIS) Progress Report to the Client First Reminder \n'

  set @Body =@Body +"\n"+ 'ddfd'

  *-----------------------------------------------------------*

  In above i get the Result is something like:

  *-----------------------------------------------------------*

  Alert Mail – I (MIS) Progress Report to the Client First Reminder \n\nddfd

  *-----------------------------------------------------------*

  I try to use \n as a line break but those get printed in the mail itself rather then breaking the line in two.

  Can you Help me out.

  Thanking you

  Regards

  Neetal Shah

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  March 10, 2006 at 6:50 am

  #625930

  Try

  set @Body = 'Alert Mail – I (MIS) Progress Report to the Client First Reminder ' + CHAR(13) + CHAR(10)

  set @Body = @Body + CHAR(13) + CHAR(10) + 'ddfd'

  Far away is close at hand in the images of elsewhere.
  Anon.

• Neetal Shah

  SSC Veteran

  Points: 220

  More actions

  March 10, 2006 at 7:45 am

  #625966

  Thanks Buddy..

  I got the solution for the same...

  Thanks alot

  Regards

  Neetal Shah