Example sql query:
DECLARE @pid INT
INSERT INTO parent ([name], [class])
VALUES('Dhinesh kumar.V', 'last')
SELECT @pid = @@IDENTITY
INSERT INTO parent (pid, age, village)
VALUES(@pid, 21, 'Best Village')
Have a look here:
INSERT (T-SQL)[
^]
@@IDENTITY[
^]