add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE blah(Col1 int, exif VARCHAR(max) );

INSERT INTO blah VALUES(1, '{"GPSVersionID":"2 2 0 0","GPSLatitudeRef":"N","GPSLatitude":"50 17 34,5155","GPSLongitudeRef":"E","GPSLongitude":"16 9 1,8972","GPSAltitudeRef":"0","GPSAltitude":"326,399","GPSTimestamp":"21 54 37","GPSMapDatum":"WGS-84","GPSProcessingMethod":"65 83 67 73 73 0 0 0 67 69 76 76 73 68 0","GPSDateStamp":"2020:06:24","Make":"motorola","Model":"Moto Z3 Play","Orientation":"1","XResolution":"72","YResolution":"72","ResolutionUnit":"2","Software":"beckham-user 9 PPWS29.131-27-1-25 b6ca4 release-keys","DateTime":"2020:06:24 23:54:37","YCbCrPositioning":"1","ExposureTime":"0,01","FNumber":"1,7","ExposureProgram":"0","PhotographicSensitivity":"91","ExifVersion":"48 50 50 48","DateTimeOriginal":"2020:06:24 23:54:37","DateTimeDigitized":"2020:06:24 23:54:37","ComponentsConfiguration":"1 2 3 0","ShutterSpeedValue":"6,643","ApertureValue":"1,53","BrightnessValue":"3,02","ExposureBiasValue":"0","MeteringMode":"2","Flash":"24","FocalLength":"4,25","MakerNote":"0x4D4F540001010101004155000002000000130000031A55120004000000010000000055020001000000015A00000055030001000000012500000055310008000000010007000055400001000000015F00000055500001000000015F00000055610008000000010000000066FF000300000001002800007000000100000001000000007001000800000001FE8F00007002000800000001FE140000700300030000000102E20000700400030000000103D80000665F0009000000010000000066600009000000010000000066610009000000010000000066630009000000010000000066640009000000010000000067030002000000070000032D670000020000000C0000033466400002000000050000034067010002000000090000034555E900020000000B0000034E6702000200000015000003596704000200000003444F000067060002000000033439000067050002000000090000036E661200030000000101EE0000661300030000000103240000661400030000000103240000661500030000000101E70000664200030000000101F80000664300030000000103220000664400030000000103210000664500030000000101F30000664F000300000001004000006650000300000001004000006651000300000001004000006652000300000001004000006654000B000000013F79562C6655000B000000013F7818CF6656000B000000013F800000660F00030000000102930000660900030000000153420000660A000300000001BE56000055E70009000000010000014855E5000900000001000000FA55E80009000000010000035455E6000900000001000003A26400000200000005000003776433000200000002300000006434000200000002300000006451000200000004302E380064100002000000034E4F0000710E00020000000A0000037C711000020000001000000386551100040000000100000703710F000200000010000003967114000200000010000003A671160002000000037B7D00007117000200000005000003B664D000020000001D000003BB665E000200000017000003D8642000020000000E000003EF000000005050575332392E3133312D32372D312D3235005072696D61780034382D35372D34392D37340030783436003238433233323637004A4843383533314233300053454D434F203132324C4F312842616E676A752900323031382F362F31004155544F003430352E3335313B2000504153534956455F464F43555345440037353334313837313235343432333900353739393035333432343730393432004E4F4E4500456E68616E63652D4E6F726D616C2D53746174652D4D616368696E65006261636B2D6D61696E2D6D6F745F73356B326C377361005363656E653A204E4F524D414C0000000000000000000000000000","SubsecTime":"530242","SubsecTimeOriginal":"530242","SubsecTimeDigitized":"530242","FlashpixVersion":"48 49 48 48","ColorSpace":"1","PixelXDimension":"4032","PixelYDimension":"3024","SensingMethod":"0","SceneType":"1","ExposureMode":"0","WhiteBalance":"0","DigitalZoomRatio":"1","SceneCaptureType":"0"}');
1 rows affected
SELECT *
FROM blah
FOR JSON AUTO
JSON_F52E2B61-18A1-11d1-B105-00805F49916B
[{"Col1":1,"exif":"{"GPSVersionID":"2 2 0 0","GPSLatitudeRef":"N","GPSLatitude":"50 17 34,5155","GPSLongitudeRef":"E","GPSLongitude":"16 9 1,8972","GPSAltitudeRef":"0","GPSAltitude":"326,399","GPSTimestamp":"21 54 37","GPSMapDatum":"WGS-84","GPSProcessingMethod":"65 83 67 73 73 0 0 0 67 69 76 76 73 68 0","GPSDateStamp":"2020:06:24","Make":"motorola","Model":"Moto Z3 Play","Orientation":"1","XResolution":"72","YResolution":"72","ResolutionUnit":"2","Software":"beckham-user 9 PPWS29.131-27-1-25 b6ca4 release-keys","DateTime":"2020:06:24 23:54:37","YCbCrPositioning":"1","ExposureTime":"0,01","FNumber":"1,7","ExposureProgram":"0","PhotographicSensitivity":"91","ExifVersion":"48 50 50 48","DateTimeOriginal":"2020:06:24 23:54:37","DateTimeDigitized":"2020:06:24 23:54:37","ComponentsConfiguration":"1 2 3 0","ShutterSpeedValue":"6,643","ApertureValue":"1,53","BrightnessValue":"3,02","ExposureBiasValue":"0","MeteringMode":"2","Flash":"24","FocalLength":"4,25","MakerNote":"0x4D4F540001010101004155000002000000130000031A55120004000000010000000055020001000000015A00000055030001000000012500000055310008000000010007000055400001000000015F00000055500001000000015F00000055610008000000010000000066FF000300000001002800007000000100000001000000007001000800000001FE8F00007002000800000001FE140000700300030000000102E20000700400030000000103D80000665F0009000000010000000066600009000000010000000066610009000000010000000066630009000000010000000066640009000000010000000067030002000000070000032D670000020000000C0000033466400002000000050000034067010002000000090000034555E900020000000B0000034E6702000200000015000003596704000200000003444F000067060002000000033439000067050002000000090000036E661200030000000101EE0000661300030000000103240000661400030000000103240000661500030000000101E70000664200030000000101F80000664300030000000103220000664400030000000103210000664500030000000101F30000664F0003000000010040000066
50000300000001004000006651000300000001004000006652000300000001004000006654000B000000013F79562C6655000B000000013F7818CF6656000B000000013F800000660F00030000000102930000660900030000000153420000660A000300000001BE56000055E70009000000010000014855E5000900000001000000FA55E80009000000010000035455E6000900000001000003A26400000200000005000003776433000200000002300000006434000200000002300000006451000200000004302E380064100002000000034E4F0000710E00020000000A0000037C711000020000001000000386551100040000000100000703710F000200000010000003967114000200000010000003A671160002000000037B7D00007117000200000005000003B664D000020000001D000003BB665E000200000017000003D8642000020000000E000003EF000000005050575332392E3133312D32372D312D3235005072696D61780034382D35372D34392D37340030783436003238433233323637004A4843383533314233300053454D434F203132324C4F312842616E676A752900323031382F362F31004155544F003430352E3335313B2000504153534956455F464F43555345440037353334313837313235343432333900353739393035333432343730393432004E4F4E4500456E68616E63652D4E6F726D616C2D53746174652D4D616368696E65006261636B2D6D61696E2D6D6F745F73356B326C377361005363656E653A204E4F524D414C0000000000000000000000000000","SubsecTime":"530242","SubsecTimeOriginal":"530242","SubsecTimeDigitized":"530242","FlashpixVersion":"48 49 48 48","ColorSpace":"1","PixelXDimension":"4032","PixelYDimension":"3024","SensingMethod":"0","SceneType":"1","ExposureMode":"0","WhiteBalance":"0","DigitalZoomRatio":"1","SceneCaptureType":"0"}"}]
SELECT Col1, JSON_QUERY(EXIF) AS EXIF2
FROM BLAH
FOR JSON AUTO

JSON_F52E2B61-18A1-11d1-B105-00805F49916B
[{"Col1":1,"EXIF2":{"GPSVersionID":"2 2 0 0","GPSLatitudeRef":"N","GPSLatitude":"50 17 34,5155","GPSLongitudeRef":"E","GPSLongitude":"16 9 1,8972","GPSAltitudeRef":"0","GPSAltitude":"326,399","GPSTimestamp":"21 54 37","GPSMapDatum":"WGS-84","GPSProcessingMethod":"65 83 67 73 73 0 0 0 67 69 76 76 73 68 0","GPSDateStamp":"2020:06:24","Make":"motorola","Model":"Moto Z3 Play","Orientation":"1","XResolution":"72","YResolution":"72","ResolutionUnit":"2","Software":"beckham-user 9 PPWS29.131-27-1-25 b6ca4 release-keys","DateTime":"2020:06:24 23:54:37","YCbCrPositioning":"1","ExposureTime":"0,01","FNumber":"1,7","ExposureProgram":"0","PhotographicSensitivity":"91","ExifVersion":"48 50 50 48","DateTimeOriginal":"2020:06:24 23:54:37","DateTimeDigitized":"2020:06:24 23:54:37","ComponentsConfiguration":"1 2 3 0","ShutterSpeedValue":"6,643","ApertureValue":"1,53","BrightnessValue":"3,02","ExposureBiasValue":"0","MeteringMode":"2","Flash":"24","FocalLength":"4,25","MakerNote":"0x4D4F540001010101004155000002000000130000031A55120004000000010000000055020001000000015A00000055030001000000012500000055310008000000010007000055400001000000015F00000055500001000000015F00000055610008000000010000000066FF000300000001002800007000000100000001000000007001000800000001FE8F00007002000800000001FE140000700300030000000102E20000700400030000000103D80000665F0009000000010000000066600009000000010000000066610009000000010000000066630009000000010000000066640009000000010000000067030002000000070000032D670000020000000C0000033466400002000000050000034067010002000000090000034555E900020000000B0000034E6702000200000015000003596704000200000003444F000067060002000000033439000067050002000000090000036E661200030000000101EE0000661300030000000103240000661400030000000103240000661500030000000101E70000664200030000000101F80000664300030000000103220000664400030000000103210000664500030000000101F30000664F000300000001004000006650000300000001004000006651000300000001004000006652000300000001004000006654000B000000013F79562C6655000B000000013F7818CF6656000B000000013F8000006
60F00030000000102930000660900030000000153420000660A000300000001BE56000055E70009000000010000014855E5000900000001000000FA55E80009000000010000035455E6000900000001000003A26400000200000005000003776433000200000002300000006434000200000002300000006451000200000004302E380064100002000000034E4F0000710E00020000000A0000037C711000020000001000000386551100040000000100000703710F000200000010000003967114000200000010000003A671160002000000037B7D00007117000200000005000003B664D000020000001D000003BB665E000200000017000003D8642000020000000E000003EF000000005050575332392E3133312D32372D312D3235005072696D61780034382D35372D34392D37340030783436003238433233323637004A4843383533314233300053454D434F203132324C4F312842616E676A752900323031382F362F31004155544F003430352E3335313B2000504153534956455F464F43555345440037353334313837313235343432333900353739393035333432343730393432004E4F4E4500456E68616E63652D4E6F726D616C2D53746174652D4D616368696E65006261636B2D6D61696E2D6D6F745F73356B326C377361005363656E653A204E4F524D414C0000000000000000000000000000","SubsecTime":"530242","SubsecTimeOriginal":"530242","SubsecTimeDigitized":"530242","FlashpixVersion":"48 49 48 48","ColorSpace":"1","PixelXDimension":"4032","PixelYDimension":"3024","SensingMethod":"0","SceneType":"1","ExposureMode":"0","WhiteBalance":"0","DigitalZoomRatio":"1","SceneCaptureType":"0"}}]
SELECT Col1,
CASE WHEN ISJSON(EXIF)=1 THEN JSON_QUERY(EXIF) END AS EXIF2
FROM BLAH
FOR JSON AUTO

JSON_F52E2B61-18A1-11d1-B105-00805F49916B
[{"Col1":1,"EXIF2":"{"GPSVersionID":"2 2 0 0","GPSLatitudeRef":"N","GPSLatitude":"50 17 34,5155","GPSLongitudeRef":"E","GPSLongitude":"16 9 1,8972","GPSAltitudeRef":"0","GPSAltitude":"326,399","GPSTimestamp":"21 54 37","GPSMapDatum":"WGS-84","GPSProcessingMethod":"65 83 67 73 73 0 0 0 67 69 76 76 73 68 0","GPSDateStamp":"2020:06:24","Make":"motorola","Model":"Moto Z3 Play","Orientation":"1","XResolution":"72","YResolution":"72","ResolutionUnit":"2","Software":"beckham-user 9 PPWS29.131-27-1-25 b6ca4 release-keys","DateTime":"2020:06:24 23:54:37","YCbCrPositioning":"1","ExposureTime":"0,01","FNumber":"1,7","ExposureProgram":"0","PhotographicSensitivity":"91","ExifVersion":"48 50 50 48","DateTimeOriginal":"2020:06:24 23:54:37","DateTimeDigitized":"2020:06:24 23:54:37","ComponentsConfiguration":"1 2 3 0","ShutterSpeedValue":"6,643","ApertureValue":"1,53","BrightnessValue":"3,02","ExposureBiasValue":"0","MeteringMode":"2","Flash":"24","FocalLength":"4,25","MakerNote":"0x4D4F540001010101004155000002000000130000031A55120004000000010000000055020001000000015A00000055030001000000012500000055310008000000010007000055400001000000015F00000055500001000000015F00000055610008000000010000000066FF000300000001002800007000000100000001000000007001000800000001FE8F00007002000800000001FE140000700300030000000102E20000700400030000000103D80000665F0009000000010000000066600009000000010000000066610009000000010000000066630009000000010000000066640009000000010000000067030002000000070000032D670000020000000C0000033466400002000000050000034067010002000000090000034555E900020000000B0000034E6702000200000015000003596704000200000003444F000067060002000000033439000067050002000000090000036E661200030000000101EE0000661300030000000103240000661400030000000103240000661500030000000101E70000664200030000000101F80000664300030000000103220000664400030000000103210000664500030000000101F30000664F000300000001004000006
650000300000001004000006651000300000001004000006652000300000001004000006654000B000000013F79562C6655000B000000013F7818CF6656000B000000013F800000660F00030000000102930000660900030000000153420000660A000300000001BE56000055E70009000000010000014855E5000900000001000000FA55E80009000000010000035455E6000900000001000003A26400000200000005000003776433000200000002300000006434000200000002300000006451000200000004302E380064100002000000034E4F0000710E00020000000A0000037C711000020000001000000386551100040000000100000703710F000200000010000003967114000200000010000003A671160002000000037B7D00007117000200000005000003B664D000020000001D000003BB665E000200000017000003D8642000020000000E000003EF000000005050575332392E3133312D32372D312D3235005072696D61780034382D35372D34392D37340030783436003238433233323637004A4843383533314233300053454D434F203132324C4F312842616E676A752900323031382F362F31004155544F003430352E3335313B2000504153534956455F464F43555345440037353334313837313235343432333900353739393035333432343730393432004E4F4E4500456E68616E63652D4E6F726D616C2D53746174652D4D616368696E65006261636B2D6D61696E2D6D6F745F73356B326C377361005363656E653A204E4F524D414C0000000000000000000000000000","SubsecTime":"530242","SubsecTimeOriginal":"530242","SubsecTimeDigitized":"530242","FlashpixVersion":"48 49 48 48","ColorSpace":"1","PixelXDimension":"4032","PixelYDimension":"3024","SensingMethod":"0","SceneType":"1","ExposureMode":"0","WhiteBalance":"0","DigitalZoomRatio":"1","SceneCaptureType":"0"}"}]