Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to set up a uato incremnt in sql server 5000 express

0 views
Skip to first unread message

tedpottel

unread,
Dec 19, 2009, 7:40:19 PM12/19/09
to
Hi,
I'm trying to get into database programming. Cannot figure out how to
do a auto int for my key value in sql server express.
Ted

Arne Vajhøj

unread,
Dec 19, 2009, 7:53:24 PM12/19/09
to
On 19-12-2009 19:40, tedpottel wrote:
> I'm trying to get into database programming. Cannot figure out how to
> do a auto int for my key value in sql server express.

Set IDENTITY on the field.

Arne

PS: This is a C# forum.

Mark Rae [MVP]

unread,
Dec 19, 2009, 8:05:20 PM12/19/09
to
"tedpottel" <tedp...@gmail.com> wrote in message
news:29a76b36-a911-425c...@c3g2000yqd.googlegroups.com...

> I'm trying to get into database programming. Cannot figure out how to

> do an auto int for my key value in SQL Server Express.

As Arne says, you set the IDENTITY flag on a numerical field.

As Arne also correctly implies, you will generally get a much better (and
quicker) response if you post in the correct newsgroup...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

0 new messages