休眠查询以获取表中特定列的逗号分隔值
问题描述:
下午好
我的疑问是我的数据库中有一个名为userinfo的表,其中一列为SenderId.现在我想使用逗号分隔符将SenderId列的所有值转换为字符串类型的数组.请告诉我如何编写对此进行休眠查询.
在此先感谢
Hi Good Afternoon
My doubt is i have a table called userinfo in my database with one of the column as SenderId.Now i want to get all the values of the SenderId column into a string type array using comma seperator.Can you please tell me how to write the hibernate query for this.
Thanks in advance
答
您好,
http ://blog.sqlauthority.com/2008/06/04/sql-server-create-a-comma-delimited-list-using-select-clause-from-table-column/ [ ^ ]
按照上面的链接.希望对您有帮助.
谢谢
sanjeev
Hello,
http://blog.sqlauthority.com/2008/06/04/sql-server-create-a-comma-delimited-list-using-select-clause-from-table-column/[^]
follow above link. hoping it will help you out.
thanks
sanjeev