USE ProofOfConcept;
GO
CREATE TABLE dbo.SelfReferencing
    (ID INT IDENTITY
            PRIMARY KEY,
     ParentID INT NOT NULL
                  DEFAULT (IDENT_CURRENT('dbo.SelfReferencing'))
                  REFERENCES dbo.SelfReferencing (ID),
     RowName VARCHAR(50));
GO
INSERT  INTO dbo.SelfReferencing
        (ParentID, RowName)
VALUES  (DEFAULT, 'Row1: Parent'),
        (1, 'Row2: Child');
GO
SELECT  *
FROM    dbo.SelfReferencing;

USE ProofOfConcept;
GO
IF OBJECT_ID(N'dbo.SelfReferencing') IS NOT NULL
	DROP TABLE dbo.SelfReferencing;
GO
CREATE TABLE dbo.SelfReferencing
    (ID INT IDENTITY
            PRIMARY KEY,
     ParentID INT NOT NULL
                  DEFAULT (SCOPE_IDENTITY())
                  REFERENCES dbo.SelfReferencing (ID),
     RowName VARCHAR(50));
GO
INSERT  INTO dbo.SelfReferencing
        (ParentID, RowName)
VALUES  (DEFAULT, 'Row1: Parent'),
        (1, 'Row2: Child');
GO
SELECT  *
FROM    dbo.SelfReferencing;