The NODE_ID_FROM_PARTS function

This function does an activity which is inverse to one of the previous functions. It generates a JSON conforming string for a given node_id from an object_id, with the help of the following code:

SELECT NODE_ID_FROM_PARTS(OBJECT_ID('dbo.TwitterUser'), 0);

It returns the JSON value that corresponds to the value for the first row in the dbo.TwitterUser node table, as shown in the following code:

-----------------------------------------------------------
{"type":"node","schema":"dbo","table":"TwitterUser","id":0}

The function return NULL if a given object_id does not belong to a node table, as shown in the following code:

SELECT NODE_ID_FROM_PARTS(58, 0);

Here is the output:

---------
NULL

The function returns NULL if a given object_id does not belong to a node table.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.22.74.66