要为数据生成计划中的每个表生成的数据的行数。
The number of rows of data to generate for each table in a data generation plan.
此选项指定首次创建数据生成计划时分配的默认行数。
This option specifies the default that is assigned when you first create a data generation plan.
必须打开或创建数据生成计划,才能指定要生成的行数。
Before you can specify the number of rows that you want to generate, you must open or create a data generation plan.
数据生成计划包含有关要用数据填充哪些表和列的信息。
The data generation plan contains the information about which tables and columns you want to fill with data.
最后,可以指定在运行数据生成计划时如何将数据添加到表。
Finally, you can specify how data is added to tables when you run a data generation plan.
可以使用“表”列中的复选框来更改数据生成计划中包括的表。
You can change which tables are included in the data generation plan by using the check boxes in the table column.
在列表中单击要应用的数据生成计划,或单击省略号浏览计划。
Click the data generation plan that you want to apply in the list, or click the ellipsis to browse for a plan.
通过预览数据,您可以调整数据生成计划,而无需反复地生成数据。
By previewing the data, you can adjust your data generation plan without generating data iteratively.
可以通过设置数据生成计划中列的属性来控制生成以填充列的数据。
You can control what data is generated to fill columns by setting the properties of the columns in the data generation plan.
如果未根据架构更改来更新数据生成计划,则不能继续修改该计划。
If you do not update the data generation plan based on the schema changes, you cannot continue to modify the plan.
现在您已经创建了一个数据生成计划,接下来必须指定要包括哪些表。
Now that you have created a data generation plan, you must specify what tables you want to include.
数据生成计划另存为数据库项目中的一个文件,您可以编辑并重用它。
The data generation plan is saved as a file in the database project that you can edit and reuse.
预览数据生成计划时,可以查看在运行计划时生成的随机数据的示例。
When you preview a data generation plan, you can see a sample of the random data that is generated when you run the plan.
还可以将每个测试项目与不同的数据生成计划、部署配置和连接字符串关联。
You can also associate each test project with a different data generation plan, deployment configuration, and connection string.
可以创建一个生成有意义数据的数据生成计划,然后将该计划链接到单元测试。
You can create a data generation plan that creates meaningful data and then link it to a unit test.
疑难解答:可以详细了解如何解决与创建和使用数据生成计划相关的常见问题。
Troubleshoot problems: You can learn more about how to troubleshoot common problems with creating and using data generation plans.
如果现在运行数据库单元测试,则数据生成计划将在测试运行开始时一次性填充数据库。
If you run database unit tests now, the data generation plan populates the database one time, at the start of your test run.
生成测试数据:预览并验证将生成的数据之后,您可以运行数据生成计划以生成测试数据。
Create a data generation plan: Create a data generation plan for each unit test project or for specific application tests.
“在运行单元测试前生成测试数据”复选框,以在运行测试前向数据库项目应用数据生成计划。
Generate test data prior to running unit tests check box to apply a data generation plan to your database project before you run tests.
如果您在数据生成计划打开的状态下尝试重命名对象,则系统将自动保存并关闭所有打开的数据生成计划,然后继续执行重命名操作。
If you have data generation plans open when you try to rename an object, all open data generation plans are saved and closed automatically, and the rename operation continues.
由于查询是动态的,在编译时并不知道其选择标准,因此,即使有了关于数据的完整的分布统计,仍然可能生成错误的计划。
Since the queries are dynamic, with unknown selection criteria at compile time, plan generation can be incorrect, even with the availability of full distribution statistics on the data.
如果不采用异步方式,则访问计划中的SHIP操作符顺序地执行,分别访问对应的昵称并生成排序后的数据流。
Without asynchrony, the SHIP operators in the plan execute sequentially to access the respective nicknames and to generate sorted streams of data.
生成的查询计划基于数据,而不是推断,因此非常高效。
The resulting query plans are based on data, rather than heuristics, and are thus extremely efficient.
根据标识出的这组差异,该分析必须确定差异的临界点,什么数据源可以解决这个差异(如果有的话),并生成一个补救或迁移计划,以消除差异。
From the set of identified gaps, the analyst must determine the criticality of the gap, what data sources may address the gap (if any), and incorporate a remediation or mitigation plan for the gap.
当应用程序向联邦系统提交一个查询时,联邦服务器识别相关数据源,并生成一个用于获得被请求数据的查询执行计划。
When an application submits a query to the federated system, the federated server identifies the relevant data sources, and develops a query execution plan for obtaining the requested data.
“动态”意味着查询作为字符串发送给数据库引擎;必须对它进行解析,并生成查询执行计划。
"Dynamic" means that the query is sent into the database engine as a string; it must be parsed and have a query execution plan generated.
使用绑定参数的原因是让数据库一次解析sql,对后续的重复请求复用生成好的执行计划,这样做节省了CPU时间和内存。
The reason for using binding parameters is to ask the database to parse your SQL once and reuse the generated execution plan for subsequent repeat requests, which saves both CPU time and memory.
当一个查询引用一个函数模板时,查询优化器尝试生成一个灵活的计划,允许在远程数据源上计算这个函数引用。
When a query references a function template, the query optimizer tries to generate a feasible plan that allows this function reference to be evaluated on the remote data source.
在此分析的基础上,该程序计划再连续发出自动生成的搜索词,以尽量提取出尽可能多的数据。
Based on that analysis, the program then fires off automated search terms in an effort to dislodge as much data as possible.
该访问计划假设,生成按prod _ id排序的数据流的排序操作被推至(push down)到两个数据源。
The access plan assumes that the sort operations to generate the data streams ordered on prod_id are pushed down to the two data sources.
应用推荐