Very Computer

Is there any way to get the automatically generated identity number when
inserting a new record using a stored procedure or any other means

Ahmed Roshdy

value that was used in the connection.   Notice that you might get the wrong
resutlst if the you inserted data to a table that had an insert trigger that
also insrted data to another table that has an identity column.  If you use
sql server 2000, then there are other function that you can use to solve

Adi

Quote:> Is there any way to get the automatically generated identity number when
> inserting a new record using a stored procedure or any other means

> Ahmed Roshdy