html怎么自动发邮件到,SQL Server 2008 自动发邮件HTML表格

DECLARE @emailBody NVARCHAR(MAX);

SET @emailBody = N'

N'th,td{border:1px solid #000000;padding:3px;}'

N'

销退单

' --标题

N'

N'

品号'

N'

品名'

N'

规格'

N'

产品序列号'

N'

数量'

N'

退货原因'

N'

' --表头

CAST(( SELECT c.ITEM_CODE AS td ,

'' ,

b.ITEM_DESCRIPTION AS td ,

'' ,

b.ITEM_SPECIFICATION AS td ,

'' ,

b.UDF021 AS td ,

'' ,

'

'

CAST(CAST(b.PRICE_QTY AS DECIMAL(20,

4)) AS VARCHAR(20))

'

' AS td ,

'' ,

b.REMARK AS td ,

''

from SALES_RETURN a

left join SALES_RETURN_D b ON a.SALES_RETURN_ID = b.SALES_RETURN_ID

left join ITEM c ON b.ITEM_ID = c.ITEM_BUSINESS_ID

where DOC_NO = '2700-201809250001'

FOR

XML PATH('tr') ,

TYPE

) AS NVARCHAR(MAX))

N'

';

SELECT @emailBody = REPLACE(REPLACE(@emailBody,

'

'>', '>');

select @emailBody

select c.ITEM_CODE,b.ITEM_DESCRIPTION,b.ITEM_SPECIFICATION,b.UDF021,b.PRICE_QTY, b.REMARK from SALES_RETURN a

left join SALES_RETURN_D b ON a.SALES_RETURN_ID = b.SALES_RETURN_ID

left join ITEM c ON b.ITEM_ID = c.ITEM_BUSINESS_ID

where DOC_NO = '2700-201809250001'