insert and get id code example Example: how to get inserted id in sql server SELECT SCOPE_IDENTITY();