Sql Server 常用操作2
摘要:
FOR XML PATH应用 stuID学生编号,sName代表学生姓名,hobby列存学生的爱好! SELECT B.sName,LEFT(StuList,LEN(StuList)-1) as hobby FROM ( SELECT sName ,SELECT hobby+',' FROM stu 阅读全文
posted @ 2016-12-19 11:02 AF陈 阅读(135) 评论(0) 推荐(0) 编辑