JASON – Igor Micev

ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

Posted on June 6, 2016 by Igor Micev — No Comments ↓

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


--table
CREATE TABLE dbo.People (
 Id int primary key nonclustered,
 InfoJson nvarchar(max) -- nvarchar(100), nvarchar(1000)
) WITH (MEMORY_OPTIMIZED=ON)

--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→