什么是以下上下文中的外部批处理。 [英] what is outer batch in following context.

问题描述

hi

    

    

   "如果临时表是由外部范围批处理创建的"

   "if the temporary table was created by an outer scope batch"

https://docs.microsoft.com/en -us / sql / sql-server / what -s-new-in-sql-server-ver15？view = sqlallproducts-allversions #databaseengine

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions#databaseengine

你真诚地

推荐答案

hi

hi

    

    

   "如果临时表是由外部范围批处理创建的"

   "if the temporary table was created by an outer scope batch"

https://docs.microsoft.com/en -us / sql / sql-server / what -s-new-in-sql-server-ver15？view = sqlallproducts-allversions #databaseengine

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions#databaseengine

你真诚的

这意味着导致执行当前语句的批处理

That means the batch which caused the execution of your current statement

作为一个例子，假设你有一个创建临时表的过程，并在调用另一个过程之前做了一些事情。使用相同的临时表数据进行一些操作的地方。

As an example say you've a procedure which creates a temporary table and does few things with it before calling another procedure where you do some manipulations with the same temporary table data.

在SQL 2019之前，这总是导致重新编译。在SQL 2019中，文章建议使用一些验证来检查临时表是否使用相同的外部代码创建，如果是，则将避免进一步重新编译后续执行。
因此，这将导致优化并消除一些开销

prior to SQL 2019, this always caused recompilation. In SQL 2019 what article suggests is it does some validations to check if temporary table was created using same outer code and if yes, it will avoid further recompilation for the subsequent executions. So this will result in optimization and removes some overhead

这篇关于什么是以下上下文中的外部批处理。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！