More then one Auto Increment Field in SQL Server

[Danial]

I have a table, in which my PK is a an AutoIncrement Number (Identity). Now I need another field which needs to be 10 Digit & Unique, is there any way i could have 2 auto increment field? I want to avoid generating the number from front end and the passing it.

I would prefere if this could be managed in Back End. Could i use trigger for that sort of thing, or any other ideas?

Thank you.

[vb_dba]

From SQL Server Books On-Line:

A table can have only one column defined with the IDENTITY property, and that column must be defined using the decimal, int, numeric, smallint, bigint, or tinyint data type.

Instead of identity columns, I have a numeric field whose value gets populated by the Stored Procedure that executes the INSERT statement. I just get the Max() column value and add 1 to it:

Create Procedure ins_myTable @Field1 varchar(50),
                             @Field2 varchar(50),
                             @Field3 varchar(50)
AS

Declare @IDCol int

Select @IDCol = Max(id_col) + 1 From myTable

If @IDCol Is Null Set @IDCol = 1

Insert Into myTable (id_col, field1, field2, field3)
Values (@IDCol, @Field1, @Field2, @Field3)

You might could try something like that.