return the identity column in sql after insert code example

Example: insert into table with only identity column

INSERT INTO TABLE_NAME DEFAULT VALUES