idententiy of row just added code example Example: how to get inserted id in sql server SELECT SCOPE_IDENTITY();