如何从数据库中断选定数据中的行 [英] How to break lines in selected data from database

问题描述

大家好，我已经显示（描述）以及其他许多东西，它在一行中显示所选任务ID的描述我想要一行一行地显示行



示例：对tfsid = 123的数据是：

1 hi

2围绕它

3保持冷静

显示：hiarounditkeepcalm



我尝试过：



我用了

Hi everyone, I have displayed(description) along with many others things its shows description of selected task Id in one line i want lines to be displayed one after one

Example : data respected to tfsid=123 is:
1 hi
2 around it
3 keep calm
it displays : hiarounditkeepcalm

What I have tried:

I have used

STUFF(
               (SELECT  description +'\n' FROM t_time_sheets where Taskid in (@ID) FOR XML PATH ('')), 1, 0, ''
           ) as Remarks

i试过使用char（10）但它不起作用

i have tried using char(10) also but it doesn't works

推荐答案

Char（10） ）将工作。使用结果文本（Ctrl + T）将结果显示为文本。

Hi,

Char(10) will work.Use Result to Text (Ctrl +T) to show result as text.

这篇关于如何从数据库中断选定数据中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！