在存储过程中混合Hekaton和常规表 [英] Mixing of Hekaton and regular tables in the stored procedure

问题描述

我试图在存储过程中使用内存表和常规表。 看起来我们不能在存储过程中混合它们。它不断给出事务对ATOMIC使用内存表的错误。然后我更改了存储的
程序以使用SNAPSHOT隔离  （BEGIN ATOMIC TRANSACTION WITH（隔离级别= SNAPSHOT）。但是这导致了问题，说它必须是本机编译的。在常规存储过程中使用普通表中的
使用内存表是否有任何指导原则？

I am trying to use both in-memory tables and regular tables in a stored procedure.  It doesn't look like we can mix them in the stored procedure. It keeps giving error that the transaction has to ATOMIC to use in-memory table. Then I changed the stored procedure to use SNAPSHOT isolation  ( BEGIN ATOMIC TRANSACTION WITH ( isolation level = SNAPSHOT) . But that caused problem saying that it has to be native compiled. Are there any guidelines in using in-memory table in a regular stored procedure along with normal tables ?

推荐答案

您可以访问存储过程中的内存表和常规表本地编译不是。

You can access both in-memory tables and regular tables in a stored proc which is NOT natively compiled.

本机编译的程序（带有native_compilation）只能访问内存表。

Natively compiled procedures (with native_compilation) can only access in-memory tables.

这篇关于在存储过程中混合Hekaton和常规表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！