本文共 932 字，大约阅读时间需要 3 分钟。

经常用到存储过程,发邮件给用户,这样写,可以节省大量的SQL

--写法1SELECT '
   
    ' + CAST((SELECT TOP 100        td=lngEmployeeID ,''      ,td=strEmployeeCode, ''       ,td=strEmployeeName,'' from Syn_Employee for XML PATH('tr'), TYPE) AS  nvarchar(MAX)) + '
'--写法2SELECT '
   
    ' + CAST((SELECT  TOP 10 * from Syn_Employee FOR XML PATH('tr'), TYPE).query('   for $item in /tr   return     
') AS NVARCHAR(MAX)) + '
    
     
            
{ $item/lngEmployeeID/text() }
            
{ $item/strEmployeeCode/text() }
            
{ $item/strEmployeeName/text() }
          
    
   
' as Result;--demo 3SELECT CONVERT(NVARCHAR(MAX), '
   '+(SELECT    (SELECT '表头' FOR XML PATH(''), TYPE) AS 'caption',    (SELECT '列1' AS th, '列2' AS th FOR XML RAW('tr'), ELEMENTS, TYPE) AS 'thead',    (        SELECT TOP 10 lngEmployeeID AS td,strEmployeeName AS td from Syn_Employee     FOR XML RAW('tr'), ELEMENTS, TYPE    ) AS 'tbody'  FOR XML PATH(''), ROOT('table'))+'');