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' |
|