How to generate autonumber column in a table?

[Rohullah]

Hello

I create a table name emp as following

crate table emp
(
empno int primary key,
Ename varchar(20)
)
now i want to when i insert record in this table
the empno should generat by itself
with out using identity.
it means how to generate autonumber minualy.

thank you in advance everyone.

[talhakarkun]

hi dear

if u are using sql database then
u can autogenerate number in ur primary key by following code..

CREATE TABLE [dbo].[emp](
[empno] [int] IDENTITY(1,1) NOT NULL,
[Ename] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_emp] PRIMARY KEY CLUSTERED
(
[empno] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]



above code ur empno will increment by 1 autogenerated automatically