SQL To Return Identity when Inserting
When inserting an identity value, use @@Identity to return the id. Replace myTable with you table name, myField with your field name, myValue with a valid value for your field. Make sure you have an identity row defined and set to auto. @@Identity will return the ID inserted into that row. ----Begin SQL---- Insert into myTable (myField) Values (myValue); Select @@Identity ----End SQL----