show generated Autonumber on successfull Insert! 2

[rajkum]

Hi,
I have a Stored Proc for inserting Data from the Web into a table with a Identity column.
i want to show back the autoNumber created to the User on successfull insert.
Please help!!

Thanks,
Raj

 

[pweegar]

Take a look at @@identity in BOL

 

[LFCfan]

also have a look at scope_identity(), which might be more suitable, depending (there's an example in BOL)

 

[SQLSister]

Never use @@identity to return the inserted value of a stored procedure. Scope_identity() will keep it to the scope of the stored procedure @@identity will not and will return the identity filed from another table if there is a trigger on the table that inserts to a second table with an identity value.