How to create custome IDENTITY(AutoIncrement) Field?

[DotNetWWW]

Hi all , What's the best solution to create a custome identity/autoincrement field in sql server 2005? thanks in advance ,

[Colin Angus Mackay]

DotNetWWW wrote:

What's the best solution to create a custome identity/autoincrement field in sql server 2005?

Do you mean other than setting IDENTITY(start, jump) on the appropriate column? You could possibly create a function and make use the function as the default value for the column. I don't know if that would work. I've never tried it.

---

Upcoming FREE developer events: * Developer Day Scotland My website | blog

[Gamzun]

go to design mode in management studio and do the changed according to your needs .....:confused: