automatic id generation

[sweatha]

Hi

I have the table named commission with 3 fields as id int, commission decimal(2,2), effectivedate smalldatetime. . I have to generate the id field automatically. To generate id feild automatically as 1,2,3,...., what code should I give in .net or wheather I should set any properties in sql server 2005

[Curtis Rutland]

In the sql server table, you should set the Identity property on the id field to Yes.

This is really basic MS SQL stuff. Perhaps you should find a tutorial?

[Frinavale]

I moved your question to MS SQL Server forum.

-Frinny

[ck9663]

Start from here

-- CK