Displaying the Identity Field

slr22 · Oct 28, 2004

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 · Oct 28, 2004

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Displaying the Identity Field

slr22

MIS

Chopstik

Technical User

Similar threads

Part and Inventory Search

Sponsor