sql return all records after insert code example Example: how to get inserted id in sql server SELECT SCOPE_IDENTITY();