Please can somebody help with the following question. I am working on a JSP/Servlet application, my servlet inserts a record into a table with an identity column(SQL Server 7). How can I do a "select @@IDENTITY" to see what the last identity inserted was. I would like to capture the identity and display it back using a JSP. Thanks. ------------------
posted 14 years ago
If you write a procedure call to do it you can return it as a result at the end in either a parm out field or a select result like ....