Sencha touch，选择主对象项目时显示详细信息(Sencha touch, Show details when selecting master objects' item)

 基本上，您可以使用DBMail，如果这是您在SQL Server中发送电子邮件的首选方法。 这是另一个线程 ，它向您展示了一个示例，并讨论了通过该方法发送查询结果的限制。 
 
 因此，将此添加到您的预定作业中，您应该得到所需的结果。 
 
 如果您想使用CSV或类似文件，以下是如何直接从MSDN控制电子邮件中的查询输出和放置： 
 
 
 
 [ @ attach_query_result_as_file = ] attach_query_result_as_file指定查询的结果集是否作为附加文件返回。 attach_query_result_as_file的类型为bit，默认值为0。 
 
 
 当值为0时，查询结果将包含在@body参数的内容之后的电子邮件正文中。 值为1时，结果将作为附件返回。 仅当指定了@query时，此参数才适用。 
 
 
 [ @query_attachment_filename =] query_attachment_filename指定用于查询附件的结果集的文件名。 query_attachment_filename的类型为nvarchar（255），默认值为NULL。 当attach_query_result为0时，将忽略此参数。当attach_query_result为1且此参数为NULL时，Database Mail会创建任意文件名。 
 
 
 [ @query_result_header =] query_result_header指定查询结果是否包含列标题。 query_result_header值的类型为bit。 值为1时，查询结果包含列标题。 当值为0时，查询结果不包括列标题。 此参数默认为1.此参数仅在指定了@query时适用。 
 
 
 [ @query_result_width =] query_result_width是用于格式化查询结果的行宽（以字符为单位）。 query_result_width的类型为int，默认值为256.提供的值必须介于10和32767之间。此参数仅在指定了@query时适用。 
 
 
 [ @query_result_separator =]'query_result_separator'是用于分隔查询输出中的列的字符。 分隔符的类型为char（1）。 默认为''（空格）。 
 
 
 如果要使用XML，则只需确保查询返回XML。 否则，您必须编写一个过程来将表格式查询格式化为XML。 
 
 这是使用SSIS 的另一条路线 ，但它更复杂，但可以让您更好地控制输出和格式。 

Basically, you can use DBMail, if that's your preferred method of sending e-mail from within SQL server. Here's another thread that shows you an example and talking about limitation of sending query results via that method.
 
So, add this to your scheduled job and you should get desired results.
 
Here's how to control the query output and placement in the e-mail straight from MSDN if you want to use CSV or similar:
 
 
 
[ @attach_query_result_as_file= ] attach_query_result_as_file Specifies whether the result set of the query is returned as an attached file. attach_query_result_as_file is of type bit, with a default of 0.
 
 
When the value is 0, the query results are included in the body of the e-mail message, after the contents of the @body parameter. When the value is 1, the results are returned as an attachment. This parameter is only applicable if @query is specified.
 
 
[ @query_attachment_filename= ] query_attachment_filename Specifies the file name to use for the result set of the query attachment. query_attachment_filename is of type nvarchar(255), with a default of NULL. This parameter is ignored when attach_query_result is 0. When attach_query_result is 1 and this parameter is NULL, Database Mail creates an arbitrary filename.
 
 
[ @query_result_header= ] query_result_header Specifies whether the query results include column headers. The query_result_header value is of type bit. When the value is 1, query results contain column headers. When the value is 0, query results do not include column headers. This parameter defaults to 1. This parameter is only applicable if @query is specified.
 
 
[ @query_result_width = ] query_result_width Is the line width, in characters, to use for formatting the results of the query. The query_result_width is of type int, with a default of 256. The value provided must be between 10 and 32767. This parameter is only applicable if @query is specified.
 
 
[ @query_result_separator= ] 'query_result_separator' Is the character used to separate columns in the query output. The separator is of type char(1). Defaults to ' ' (space).
 
 
If you want to use XML, you just have to make sure your query returns XML. Otherwise, you'd have to write a procedure to format tabular query as XML. 
 
Here's another route using SSIS, but it's more involved, but gives you more control over the output and formatting.