sqlparse.ftv_sqlparse - IF
type: IF ( inline function ), modify_date: 2021-04-13 19:02:37
RepoObject_guid: 2B90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
sql_modules_definition
sqlparse.ftv_sqlparse - IF script
CREATE Function [sqlparse].ftv_sqlparse
(
@json_array NVarchar(Max)
)
Returns Table
As
Return
(
Select
j1.[Key] As json_key
, j2.*
From
OpenJson ( @json_array ) j1
Cross Apply
OpenJson ( j1.Value )
With
(
class NVarchar ( 500 ) N'$.class'
, is_group Bit N'$.is_group'
, is_keyword Bit N'$.is_keyword'
, is_whitespace Bit N'$.is_whitespace'
, normalized NVarchar ( Max ) N'$.normalized'
, children NVarchar ( Max ) N'$.children' As Json
----get values of some children
----children[0] is the first children
--,child0_class nvarchar(500) N'$.children[0].class'
--,child0_is_group bit N'$.children[0].is_group'
--,child0_is_keyword bit N'$.children[0].is_keyword'
--,child0_is_whitespace bit N'$.children[0].is_whitespace'
--,child0_normalized nvarchar(MAX) N'$.children[0].normalized'
--,child0_children nvarchar(MAX) N'$.children[0].children' AS JSON
--,child1_class nvarchar(500) N'$.children[1].class'
--,child1_is_group bit N'$.children[1].is_group'
--,child1_is_keyword bit N'$.children[1].is_keyword'
--,child1_is_whitespace bit N'$.children[1].is_whitespace'
--,child1_normalized nvarchar(MAX) N'$.children[1].normalized'
--,child1_children nvarchar(MAX) N'$.children[1].children' AS JSON
) j2
);