如何在sql server 2008中添加新的字符行 [英] How to put new character line in sql server 2008

问题描述

如何在Sql Server中添加新字符行



数据来自两列。我已经尝试过以下但是没有工作。



PhoneNumber + CHAR（13）+ CHAR（10）+ EmailID as PhoneEmail



如果有人知道帮帮我





谢谢

bajid

How to put New character line in Sql Server

The data come from two columns. Im Already tried below one but its not working.

PhoneNumber + CHAR(13) + CHAR(10) + EmailID as PhoneEmail

Help me if any one know


Thanks
bajid

推荐答案

如果您正在尝试调试SP，请尝试 http://msdn.microsoft.com/en-us/library/xehsh1hb.aspx [ ^ ]。

If you are trying to debug an SP, try http://msdn.microsoft.com/en-us/library/xehsh1hb.aspx[^].

你的意思是换行？断点是完全不同的。



我从来没有这样做过，但幸运的是，我知道如何使用google [ ^ ]。简短版本，char（13）是正确的，不需要char（10）。



它可能取决于你输出字符串的位置。老实说，我认为你最好在你的表现层添加换行符，它是显示的功能，而不是数据的功能

You mean line breaks ? A break point is something completely different.

I've never done this, but lucky for you, I know how to use google[^]. Short version, char(13) is right, char(10) is not needed.

It probably depends on where you output the string, as well. Honestly, I think you're better off adding the line break in your presentation layer, it's a function of display, not of data

这篇关于如何在sql server 2008中添加新的字符行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！