Posts Tagged ‘autonumber’

Autonumber using Stored Procedure in SQL Server

Friday, January 16th, 2009

Today I want to share an SQL Server 2005 stored procedure to make autonumber. This stored procedure provide two numbering templates.

autonumber template #1: ..
autonumber template #2: <1DIGIT-YEAR><1DIGIT-MONTH>.

sqlserver-autonumber

(more…)