Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

The starting value and increment step are specified as parameters for this property. Each time a new record is added and IDENTITY_INSERT is set to OFF, the IDENTITY column value increases by the ...