B*********L
发帖数: 700 | 1 下面的，是现在的code。其中A column，希望变成Hyperlink，怎么改比较简洁？谢谢
了。
DECLARE @SQLString nvarchar(max)
SET @SQLString = N'
SET NOCOUNT ON;
SELECT A,B,C FROM TABLE1
SELECT A,E,F FROM TABLE2
SELECT A,H,K FROM TABLE3
SELECT A,X,Y FROM TABLE4
'
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'yyy'
, @recipients = 'x*[email protected]'
, @subject = 'TEST'
, @query = @SQLString
, @exclude_query_output = 1
, @query_no_truncate = 0
, @query_result_header = 1
, @append_query_error=1 | s**********o
发帖数: 14359 | | B*********L
发帖数: 700 | 3 总算可以了：
DECLARE @tableHTML NVARCHAR(MAX)
SET @tableHTML =
N'
SET NOCOUNT ON;
PRINT ''name NAME_html
''
SELECT [name]
,''http://xxxx.com/Report.aspx?ID='' + [name] + ''>'' + [name] + ''''
,''
''
FROM table WITH (NOLOCK)
' ;
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'RF_Performance'
, @recipients = 'l*****[email protected]'
, @subject = 'test'
, @importance = 'High'
, @query = @tableHTML
, @exclude_query_output = 1
, @query_no_truncate = 0
, @query_result_header = 0
, @append_query_error=1
, @body_format = 'HTML' |
|
