字符串值回车 [英] string value carriage return

问题描述

您好，我在表格中有一个文本列.此列文本为多行，并且当我必须将其呈现到应用程序中时.我希望它能够呈现出原来的样子.

例如.

INSERT INTO tbCode(代码，[类型]，标题，定义，定义)
VALUES('051'，
'V'，
'取消注册，无效日期'，
'BAD DATE'，'由于提交的交易无效，交易失败或被拒绝.'+ char(13)+'如果theDate为空白或包含一个非空白的无效日期，则交易将失败文件'+ char(13)+'如果生效日期包含的有效日期不适合提交的交易.')

现在您可以看到，我使用char(13)来放置运输工具返回，但是当我在数据库或应用程序中打开它时，它没有返回回车.

那我该怎么办，这样它才能回车.

最初的数据是交易失败或由于提交的交易无效而被拒绝.
如果日期为空或包含非空白的无效日期，则交易将失败file
生效日期是否包含不适用于所提交交易的有效日期.

谢谢

---

我是新手还是学生

Hi, I have a text column in a table. This column text in multiple lines and when I have to render it into the application. I want it to render the way it was originally.

For example.

INSERT INTO tbCode(Code,[Type],Title,Definition,Definition)
VALUES('051',
'V',
' Disenrollment Rejected, Invalid Date ',
'BAD DATE  ','A transaction  failed or was rejected because the submitted for was not invalid . '+ char(13) + 'If theDate is blank or contains a non-blank invalid date, the transaction is returned will Failed Transaction file '+ char(13) + 'If the Effective Date contains a valid date that is not appropriate for the submitted transaction.')

Now as you can see I used the char(13) to put the carriage return but when I am opening it up in the database or in the application it is not returning carriage.

So what should I do so it return carriage.

Originally the data was
A transaction failed or was rejected because the submitted for was not invalid.
If the Date is blank or contain a non blank invalid date, the transaction is required will Failed Transaction file
If the Effective Date contains a valid date that is not appropriate for the submitted transaction.

Thanks

---

i am a novice and a student

推荐答案

此论坛适用于基于云的数据服务.请在下面的SQL Server论坛中发布您的问题:

http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=93&SiteID=1

有关所有SQL Server的列表论坛，请参阅:

http ://forums.microsoft.com/MSDN/default.aspx?ForumGroupID = 19& SiteID = 1

This forum is for cloud based data services.  Please post your question to the SQL Server forum bellow:

http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=93&SiteID=1

For a list of all SQL Server forums please see:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

这篇关于字符串值回车的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！