本文介绍了如何从数据库中断选定数据中的行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,我已经显示(描述)以及其他许多东西,它在一行中显示所选任务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
推荐答案
这篇关于如何从数据库中断选定数据中的行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!