我如何在此行中使用中断线 [英] how can i use break line in this line

问题描述

朋友们，
我想问一下SQL.

  IF ( @ DATEDifferenceID1 < =  AND   @ DATEDifferenceID1 <  0 )
开始

 SET   @ ErrorMessage  = ' '〜客户个人主要 ID  ID 即将过期在中' ' + LTRIM(STR( @ DATEDifferenceID1 ))+ ' '天. ' ' +  Char ( 10 )+ ' '您是否  喜欢继续和 '  SET   @ ErrorCode  =  1001 
 END  

我正在使用这一行代码，并且它显示这样的错误消息

line1 ..............
line2 ..............

但我想显示这样的错误消息

line1 ..............

line2 ..............

意思是说我想添加一条额外的实线..
请帮帮我，我该如何在SQL 2008中做到这一点呢?
例如

  SET   @ ErrorMessage  =  ' 第1行' +  CHAR ( 13 )+ ' 第2行' 

Hi friends,
I want to ask about SQL.

IF(@DATEDifferenceID1 <= 90 AND NOT @DATEDifferenceID1 < 0 )
BEGIN
	
	SET @ErrorMessage = ''  ~ Customer Personal Primary ID is expiring in '' + LTRIM(STR(@DATEDifferenceID1)) + '' Day(s). '' + Char(10) + '' Would you like to proceed and save the remittance?''
	SET @ErrorCode = 1001
END

i am using this line of code.and it display my error message like this

line1..............
line2..............

but i want to display my error message like this

line1..............

line2..............

mean to say i want to add an extra breal line..
helpout me please how can i do this in SQL 2008???

解决方案

I think CHAR(13) is the line break.
So for example

SET @ErrorMessage = 'Line 1' + CHAR(13) + 'Line 2' 

这篇关于我如何在此行中使用中断线的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！