Obtaining default values after an INSERT

I am inserting a row into a database, and some columns insert default values
(such as an @@identity column and a (getdate()) column). Though I can get
the identity through @@identity, is there a way to get the other default
values without having to query the table again using the @@identity? The
only two options I see are:

1) Manually create the default value in the stored procedure and pass the
value into the INSERT. This gives me the value after the INSERT.

2) Call INSERT and do a SELECT to query for the default value.

Is there any other way to get the default value without manually create the
value in the stored procedure, or having to SELECT for it?

Thanks

I am inserting a row into a database, and some columns insert DEFAULT
values (such as an @@IDENTITY column [sic: it is not a column, but a
property; don't use it at all] and a GETDATE() [use CURRENT_TIMESTAMP
now that we have it] column). Though I can get the IDENTITY through
@@IDENTITY, is there a way to get the other DEFAULT values without
having to query the table again using the @@IDENTITY? <<

>> Is there any other way to get the DEFAULT value without manually create the value in the stored procedure, or having to SELECT for it? <<

Unh? Look at the DDL and find out what the DEFAULT is for each
column. You don't create them in a procedure; they are part of the
table declarations. Can you explain what you are talking about?

Instead of writing GETDATE(), use the Standard CURRENT_TIMESTAMP now
that we have it. And you would never use IDENTITY at all in a
properly designed schema.

You might also want to look up the "INSERT INTO <table name> DEFAULT
VALUES;"