Emulations

• Cursors are refactored into temporary tables and loops

• MERGE statements are transformed into equivalent combination of DELETE, UPDATE, and INSERT statements

• Identity columns are transformed into standard columns and all statements inserting data into tables are modified to insert monotonously-increasing values into the now standard (big)int columns

• Tables with computed columns are transformed into a table without computed columns plus a view referencing that table and adding computed columns. Any code referencing the original table is updated to reference the view.

• Temporary tables are transformed into standard tables with session IDs and timestamps encoded into their name. All code touching temporary tables is transformed into dynamic SQL because table names become dynamic.

• Database-wide name references are rewritten so that case-insensitive code won't break in case-sensitive Fabric Warehouse

• SET ROWCOUNT is deleted and statements after it are transformed to achieve the same effect. In cases where static analysis cannot determine correct transformation, a limitation is reported instead.

• Named EXEC parameters are refactored to positional parameters