SQL Server GDB - Insert Data to Node and Edge

insert_node_and_edge.sql

DECLARE @ParentNodeId nvarchar(1000), @ChildNodeId nvarchar(1000)
DECLARE @EntityNodeDetails table(NodeId nvarchar(1000));  

-- Insert the Facebook as parent organization
INSERT dbo.Entity ([Name], [Code], [Type])
	OUTPUT INSERTED.$node_id
	INTO @EntityNodeDetails
	VALUES ('Facebook, Inc.', 'FB', 'Public')
-- Get inserted nodeId to variable
SELECT TOP 1 @ParentNodeId=NodeId FROM @EntityNodeDetails

-- Insert WhatsApp 
DELETE FROM @EntityNodeDetails
INSERT dbo.Entity ([Name], [Code], [Type])
	OUTPUT INSERTED.$node_id
	INTO @EntityNodeDetails
	VALUES ('WhatsApp Inc.', 'WhatsApp', 'Private')

SELECT TOP 1 @ChildNodeId=NodeId FROM @EntityNodeDetails
-- Make WhatsApp as a Subsidiary of Facebook
INSERT INTO dbo.Subsidiaries VALUES (@ParentNodeId, @ChildNodeId, 100.00, '2014-02-19');

-- Insert Instagram
DELETE FROM @EntityNodeDetails
INSERT dbo.Entity ([Name], [Code], [Type])
	OUTPUT INSERTED.$node_id
	INTO @EntityNodeDetails
	VALUES ('Instagram, Inc.', 'Instagram', 'Private')

SELECT TOP 1 @ChildNodeId=NodeId FROM @EntityNodeDetails
-- Make Instagram as a Subsidiary of Facebook
INSERT INTO dbo.Subsidiaries VALUES (@ParentNodeId, @ChildNodeId, 100.00, '2012-09-06');