Identity,Identity Seed, Identity Increment properties

On Wed, 20 Apr 2011 11:48:54 -0700 (PDT), iccsi
wrote:

>If I set Identity property to true and set Seed to 1 and increment to
>1 then SQL Server will automatically insert and increment the value
>for users or programmer still needs to insert the value be code?

SQL Server will do it.

Sincerely,

Gene Wirchenko

On Apr 20, 4:02*pm, Gene Wirchenko wrote:
> On Wed, 20 Apr 2011 11:48:54 -0700 (PDT), iccsi
> wrote:
>
> >If I set Identity property to true and set Seed to 1 and increment to
> >1 then SQL Server will automatically insert and increment the value
> >for users or programmer still needs to insert the value be code?
>
> * * *SQL Server will do it.
>
> Sincerely,
>
> Gene Wirchenko

So Identity and seed and increment equals auto number in MS Access?
Thanks agin for helping,

iccsi (inunghatgmaildotcom) writes:
> So Identity and seed and increment equals auto number in MS Access?

Yes. With the caveat that I don't know Access.

--
Erland Sommarskog, SQL Server MVP, esquelatsommarskogdotse

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx