sp_send_dbmail [ [ @profile_name = ] ' profile_name ' ]
[ , [ @recipients = ] ' recipients [ ; n ] ' ]
[ , [ @copy_recipients = ] ' copy_recipient [ ; n ] ' ]
[ , [ @blind_copy_recipients = ] ' blind_copy_recipient [ ; n ] ' ]
[ , [ @subject = ] ' subject ' ]
[ , [ @body = ] ' body ' ]
[ , [ @body_format = ] ' body_format ' ]
[ , [ @importance = ] ' importance ' ]
[ , [ @sensitivity = ] ' sensitivity ' ]
[ , [ @file_attachments = ] ' attachment [ ; n ] ' ]
[ , [ @query = ] ' query ' ]
[ , [ @execute_query_database = ] ' execute_query_database ' ]
[ , [ @attach_query_result_as_file = ] attach_query_result_as_file ]
[ , [ @query_attachment_filename = ] query_attachment_filename ]
[ , [ @query_result_header = ] query_result_header ]
[ , [ @query_result_width = ] query_result_width ]
[ , [ @query_result_separator = ] ' query_result_separator ' ]
[ , [ @exclude_query_output = ] exclude_query_output ]
[ , [ @append_query_error = ] append_query_error ]
[ , [ @query_no_truncate = ] query_no_truncate ]
[ , [ @mailitem_id = ] mailitem_id ] [ OUTPUT ]
sqlserver中这个系统自带存储过程中,收件人参数 [ @recipients = ] ,怎样加上收件人的昵称,而不是只写邮件地址