how to insert with id=increment

[Thomas Henz]

Hi!

I'm coming straight from php and mysql and I want to run this INSERT
command from asp.net to mssql with ID as PK and auto incremented.

ID PK int(4)
name varchar(50)
nummer int(4)

When doing e.g.:

INSERT INTO test (name,nummer) VALUES ('tom','2222')

it doesnt work because ID can't be NULL. Thats ok, but how do I change
it that ID gets autoincremented?

Thanks a lot,

Tom

[Ray at]

Check out CREATE TABLE in Books Online.
[ID] [int] IDENTITY (1, 1) NOT NULL
(First one is the seed (start at), and second is the increment)

Ray at work

"Thomas Henz" <thenz@t-online.de> wrote in message
news:bikust$pbs$01$1@news.t-online.com...

> Hi!
>
> I'm coming straight from php and mysql and I want to run this INSERT
> command from asp.net to mssql with ID as PK and auto incremented.
>
> ID PK int(4)
> name varchar(50)
> nummer int(4)
>
> When doing e.g.:
>
> INSERT INTO test (name,nummer) VALUES ('tom','2222')
>
> it doesnt work because ID can't be NULL. Thats ok, but how do I change
> it that ID gets autoincremented?
>
> Thanks a lot,
>
> Tom
>

[Aaron Bertrand - MVP]

This was answered in a SQL Server group. Please don't multi-post.



"Thomas Henz" <thenz@t-online.de> wrote in message
news:bikust$pbs$01$1@news.t-online.com...

> Hi!
>
> I'm coming straight from php and mysql and I want to run this INSERT
> command from asp.net to mssql with ID as PK and auto incremented.
>
> ID PK int(4)
> name varchar(50)
> nummer int(4)
>
> When doing e.g.:
>
> INSERT INTO test (name,nummer) VALUES ('tom','2222')
>
> it doesnt work because ID can't be NULL. Thats ok, but how do I change
> it that ID gets autoincremented?
>
> Thanks a lot,
>
> Tom
>