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----
----Begin SQL----
Insert into myTable (myField)
Values (myValue); Select @@Identity
----End SQL----
Comments