Scope identity

INSERT INTO TREE (name) VALUES('myTree');
SELECT VISIBLEID FROM TREE WHERE ID = SCOPE_IDENTITY();