Year Based Primary Key?

Question

How can I create a Primary Key in SQL Server 2005/2008 with the format: CurrentYear + auto-increment?

Example: The current year is 2010, in a new table, the ID should start in 1, so: 20101, 20102, 20103, 20104, 20105... and so on.

Answer 1

The cleaner solution is to create a composite primary key consisting of e.g. Year and Counter columns.