How to manage identity column in In-Memory tables

As there are certain limitation which I also mentioned in my previous articles.
One of them is identity is not supported.
So when there is identity column is used in table we have to change code and use SEQUENCE instead.

Lets see an example

Transact SQL options not supported on In-Memory Tables

In-Memory tables are great enhancement but also there is certain limitation also while using it.
Below is Transact SQL Constructs which are not supported in In-Memoery Tables compare to disk based tables.

Creating In Memory OLTP Tables

This is second article on In Memory table.
Lets see how to create In Memory tables.

Lets create a new database.

Index in In Memory OLTP Tables.

In Memory OLTP is a new revolution in OLTP for SQL Server users.
The feature supports extremely fast transaction but as every feature we have to also
Handling in memory table is quite different compare to normal tables and we have to be ready for it.