Displaying the Identity Field
Displaying the Identity Field
(OP)
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
Can anyone help me out?
Thanks,
Sandy
RE: Displaying the Identity Field
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