SQL Server Invalid version: 15 (Microsoft.SqlServer.Smo)
Using SSMS version 18.0 instead of 17.0 seems to be working. You can download it from https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
open-json
SQL Server OPENJSON read nested json
Using CROSS APPLY: declare @json nvarchar(max) set @json = ‘ [ { “IdProject”:”97A76363-095D-4FAB-940E-9ED2722DBC47″, “Name”:”Test Project”, “structures”:[ { “IdStructure”:”CB0466F9-662F-412B-956A-7D164B5D358F”, “IdProject”:”97A76363-095D-4FAB-940E-9ED2722DBC47″, “Name”:”Test Structure”, “BaseStructure”:”Base Structure”, “DatabaseSchema”:”dbo”, “properties”:[ { “IdProperty”:”618DC40B-4D04-4BF8-B1E6-12E13DDE86F4″, “IdStructure”:”CB0466F9-662F-412B-956A-7D164B5D358F”, “Name”:”Test Property 2″, “DataType”:1, “Precision”:0, “Scale”:0, “IsNullable”:false, “ObjectName”:”Test Object”, “DefaultType”:1, “DefaultValue”:”” }, { “IdProperty”:”FFF433EC-0BB5-41CD-8A71-B5F09B97C5FC”, “IdStructure”:”CB0466F9-662F-412B-956A-7D164B5D358F”, “Name”:”Test Property 1″, “DataType”:1, “Precision”:0, “Scale”:0, “IsNullable”:false, “ObjectName”:”Test Object”, “DefaultType”:1, “DefaultValue”:”” } … Read more