c# - Store Primary Key after SQL Query -

following situation:

i have asp.net website create vm's in esx environment. user can select settings , click on button create vm.

the click-event of button checks values , write ms sql server. table has primary key (integer, identity) don't need insert (because identity).

but need primary key, because redirect user after event page , page needs primary key regular queries (send querystring).

currently, make select query direct after insert into query , take last entry. works long 1 user uses page.

my question is:

is possible recieve identity primary key directly insert into query (like return value function) ?

off top of head, @@identity want here.

that of course assuming using ms sql server.

eg insert xxx.... ; select @@identity

edit:

as mitch wheat pointed out, @@scope_identity better option @@identity. because @@scope_identity returns id in current scope, whereas @@identity may return id created trigger or udf.