Displaying the Identity Field

[slr22]

I have set up my SQL table to accept an Identity field. Once I have added a row to my table, I want to be able to display that identity value on the next page. I cannot figure out how to do this. I normally would use a session variable to get this value, however with it not being created until after it as been inserted in the table, I'm stumped.

Can anyone help me out?

Thanks,
Sandy

 

[Chopstik]

Sandy,

This question might be better off in the SQL forum (forum183). However, you can simply get the @@Identity immediately after your insert statement. For more help on this, check BOL (Books OnLine - which comes with SQL Server).

------------------------------------------------------------------------------------------------------------------------
If you don't have a sense of humor, you probably don't have any sense at all.
- Anonymous