Re: identity seed
From: Samuel (samuel_at_hotrmail.com)
Date: 10/11/04
- Next message: Aryan: "Moving DataBase"
- Previous message: lolo: "sqlH2 pb with insert statement"
- In reply to: Wayne Snyder: "Re: identity seed"
- Next in thread: Adam Machanic: "Re: identity seed"
- Reply: Adam Machanic: "Re: identity seed"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 11 Oct 2004 16:31:18 +0200
Hi Wayne,
I just wanted to start from 01.
How about related tables where i want the identity must start with 001 if
the main table starts with 1. For each new record in the main table, the
related table must rebuild the identiy to begin with 001.
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:eNGWeh5rEHA.4032@TK2MSFTNGP12.phx.gbl...
> Identity values are integers, and the value of 01 an 1 are identical. So
> there is no difference...
>
> Is there something more in your question?
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Samuel" <samuel@hotrmail.com> wrote in message
> news:%23E7VLd5rEHA.192@tk2msftngp13.phx.gbl...
> > Hello,
> >
> > How can i set a identity column to start with 01 instead of 1?
> >
> > Thnx
> >
> >
>
>
- Next message: Aryan: "Moving DataBase"
- Previous message: lolo: "sqlH2 pb with insert statement"
- In reply to: Wayne Snyder: "Re: identity seed"
- Next in thread: Adam Machanic: "Re: identity seed"
- Reply: Adam Machanic: "Re: identity seed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
