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
posted @ 2016-12-19 11:02
posted @ 2016-12-15 10:58
posted @ 2016-12-14 16:44