ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like in the example below
1 2 3 4 5 6 7 |
--table CREATE TABLE dbo.People ( Id int primary key nonclustered, InfoJson nvarchar(max) -- nvarchar(100), nvarchar(1000) ) WITH (MEMORY_OPTIMIZED=ON) |
try to create the next constraint Continue reading ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017