CLR triggers the garbage collection when one of the following event occurs :
- GC.Collect() Method is called explicitly by code.
- Windows reporting low memory condition via Win32 notification.
- When CLR Unloads the AppDomain.
- When CLR is shutting down.
CLR triggers the garbage collection when one of the following event occurs :
Sql server allows you to parse Json data with OpenJson .
Sample Json data : [{“MinValue”:”1″,”MaxValue”:”6″}]
Parsing Json to map into Tables:
declare @metadata="[{"MinValue":"1","MaxValue":"6"}]" select Minvalue,MaxValue from openjson(@metadata) with (MinValue nvarchar(2),MaxValue nvarchar(2));