How can I create a Primary Key in SQL Server 2005/2008 with the format: <code>CurrentYear + auto-increment</code>? 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.

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

Year Based Primary Key?

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

142

answered Sep 24 '22 04:09

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!