sql server换行符 [英] sql server new line character

问题描述

HI，

我正在以逗号分隔的方式从数据库(sql server)获取记录.我正在获取联系
标题为

greg w.workcerf，阿什尔·阿里，asdddfgjk

这是逗号分隔符，已在sql函数getCommaListTitle中定义

我想要的是将这些记录换成新的行

greg w.workcerf，
阿瑟·阿里(ashir ali)，
asdddfgjk

关于我应该在sql函数而不是''，''中使用的任何想法，

I am getting records from database(sql server)as comma separated.I am getting contact
titles as

greg w.workcerf,ashir ali,asdddfgjk

This is comma separater has been defined in sql function getCommaListTitle

What i want is to get these record on new lines as

greg w.workcerf,
ashir ali,
asdddfgjk

Any idea about what should i use in sql function instead of '',''

推荐答案

如果我理解正确，则需要去更改SQL函数.

在您的SQL函数中，在您的``,''之后放置CHAR(13);或CHAR(10);
这将在您尝试获取的文本格式的文本中插入回车符(代码13)或换行符(代码10).

If I understood correct, you need to go and change your SQL Function getCommaListTitle.

Here in your SQL function, after your '','' put CHAR(13); or CHAR(10);
This will insert carriage return(code 13) or newline feed(code 10) in the text leading to the text format as you are trying to get.

假设您正在C#中进行操作.

Assuming you are doing it in C#.

string s = "greg w.workcerf,ashir ali,asdddfgjk";

string finalString = s.Replace(",", ",\r\n");    //in case it is goiing on windows form
string finalString = s.Replace(",", ",<br />");    //in case it is goiing on web form

HI All,

Thanks for your quick responses,
Surprisingly,this

<br>', ''

 worked in sql server function .Now i am getting required output

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