— using https://www.sqlshack.com/the-json_query-function-to-extract-objects-from-json-data/ — ISJSON(): we can check valid JSON using this function SELECT TOP (1000) [gscData],[gscSiteUrl],[gscDate],[insDate],[insDateUTC],ISJSON(convert(nvarchar, gscData)) as is_jsonFROM [dwhlite].[gsc].[dat_google_search_console]; — tk: json functions in SQL Server— ISJSON(): we can check valid JSON using this function— JSON_VALUE(): It extracts a scalar value from the JSON data— JSON_MODIFY(): It modifies […]
sql server
2 posts
What is SQL Server? SQL Server is a relational database management system (RDBMS) from Microsoft. In a very simple sense, it is a database system, by means of which we manage database elements such as tables, views, programming elements. SQL Server is currently the flagship database server offered by Microsoft. […]