SQL FOR xml PATH 用法FOR XML PATH 有的人可能知道有的人可能不知道，其实它就是将查询结果集以XML形式展现，有了它我们可以简化我们的查询语句实现一些以前可能需要借助函数活存储过程来完成的工作。那么以一个实例为主.
这是一张存放员工的任务表（数据乱填的，表也是随意建的）
FOR XML PATH 用法如下：
SELECT * FROM TBL_Task_info FOR XML PATH
查询结果：
ipSiIpUv8knwfGxR1ZsizxvCYlnfPyIgDJ8efPn//z5D//9R//+Nf/9F07iA0/egaXNU7s9/XS4/q9xqcCzOXPnz//681//Ms/Xf753/3X9+Tf//nyT//yH6t/7GxWkTrAufjz58//QB+kDgny58+f/4Y+SB0S5M+fP/8FfZA6JMgfGIHUAbIAQQNkAVIHyAKkDpAFSB0gCy7/ZsKxwc+XXC6ybjrc9SKfX6t+IgD0MfTqVqn/yOdFLp/dgkfx8ffj41Y9f6vi78fH34/y1X9LX9guKetmhVf58ffj429RNX9+fcrlIl8/qxwUAAzxlbpVinXZKbYu77WIyKP4uFXPboXm3Wd1e+u84VUWj6f29+inBADWYlrqzYjdOsCuy07VDXZJP4ry1XTvRSVS399desDuAGAWw2t1sffqZvmFSP1VFo9nfS+qV1k86uFq0uicXh1gAwKu1c1j+LHURR6FPjLXeu+6vJflrXpKXd6K4q4rndE7wJaE3JaTgSDr+4e69/bx9+Ojk+6zulmXN78C9f2j+zm4XrgnB7AtgVIHgDgJfq4OADFCthxAFiB1gCxA6gBZ0Eqd63OAtEHqAFmA1AGyAKmvzM8XCfxwRnaUej+FTq94XYu2MFa9mhz7WfttJqz5DM/gu6pi/qiOF5Jnc6n3rCzqUtWrS11uFIW/VTFMy7fs12aJ8fP1ebl+y/fVIXWjRcewS4/keCEHtpT6uIJFD8F+jI6tLBq6jquo+lU0ViZCv7+CyxLDJnV7Zc51IP64jheSZiup28rg9BBUf5qtLJq4f6//WxV/P9YJ/eGfNumapO6QiuEqPa7jhaRZX+oubwljCFrr283eFZMEh77ta/elPumZMezSbfs97fFC0mzYqxvCyDiw3D30xyuYLTEsvbrl8j7+44Wk2fBa3TDW7YVgfe8cJs1WFq9SG+hKfddL3+1MhX63XxHnaNZyrW4cwxu6dPt+T3q8kDQb34HXA2v4EMjDyqJ3+2o67v0ePnWfY7PEaJ60dYz7675gzF16PMcLOUAKzQpc0Q+cHqQOkAVIHSAL4pP64EJUJaIc/b22IrfjhY2IT+oAMAOkDpAFSB0gC5A6QBYg9Z3AsgKOZT+pv+dg119elVtjHkXYtqeyrEjjPEB07GdNoVK1X+XHexr2mSE+b9uTWFYkcB4gRva1phARLcQ76lL1KoMo7HLCi+KmFX41Ia71kNPPmU9kWSEiCZwHiIp9rSlExBzitRo0PoruXT3mXuXHX3OI+w44T2RZISIJnAeIin2tKUTEGOLWSi99XudeKLe9XEiB94ksK0QkgfMAUbGvNYWIGEK8N9f6b1WYizc1YyZpOr0yzJjxRJYVIpLAeYCo2NeaQkTGIf6suovPZ3XTerPePad+OLZvhdiwnsiyQkQSOA8QFTtaUwyfM3XxpC0v7mWhxq66T4O+vnrIpJ4eDWO3z7ksK+I/DxAjpNBsCJYVcB6QOkAWIHWALEhH6lg4NHAewEg6UgcAB0h9Dy4X34We7wKEgtT3YKDby6V7eW4CsBCkvgeNbn0UrtY3vgBmg9Q3ZyzRyaF76CYrgoVGqqRvTdGkiDVpZN13mDUR4jyCdKve0v+zZ39+uIXG4e2VKllYU7zK4la880n1VPOVcFg4LOmiNxX5mS00DmyvhMnCmuJVFo+q7FK+1eeM99skhBfFvck2b1fQwk51cf34s9X2zJO6vtX6gj+9hcaB7ZUwWVhTNBOYt9OY90LH