Dynamic update or script equivalent in SQL Server in-memory OLTP (Hekaton)

90 Views Asked by At

I want to write equivalent stored procedure (contain execute string) in natively compiled stored procedure, but I can't find a way to implement that.

Does anyone have an idea?

1

There are 1 best solutions below

0
On

There are limited set of operators that can be used in natively compiled stored procedures.

You are allowed to use control-of-flow language statements like IF and ELSE, so this is the closest thing you can get to dynamic execution.