Auto Number SQL Server 2000

Hi all,

How can i generate auto Number in SQL Server 2000,like AutoNumber Datatype in MsAccess...

Thanx in advance

Sajjad

UseIDENTITY

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_8g9x.asp

|||

Hi

Here is how you can do that with WebMatrix, from theGuided Tour

Using IsIdentity