I’ve managed to pass the following exams so far:
- 461 – Querying Microsoft SQL Server 2012
- 462 – Administering Microsoft SQL Server 2012 Databases
- 464 – Developing Microsoft SQL Server 2012 Databases… 338 more words
In SQL Server 2012 the SEQUENCE object was added. This seems to be to get past some of the deficiencies in the IDENTITY property.
It allows you to use the same sequence across multiple columns in multiple tables whereas the IDENTITY property is linked to a particular column within a particular table. 461 more words