Re: SQL Express - Identity specification property - how to change

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Sat, 24 Nov 2007 17:25:24 +0000 (UTC)

Mike (ablyplus@xxxxxxxxx) writes:

I want to use Identity specification because I'd like to get
autoincremental values started from 1 to n

For the existing data? Why? Assuming that the id is an artificial key,
the values are of no importance, and 5 is as good as 98987.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Follow-Ups:
- Re: SQL Express - Identity specification property - how to change
  - From: Mike

References:
- SQL Express - Identity specification property - how to change
  - From: Mike
- Re: SQL Express - Identity specification property - how to change
  - From: Erland Sommarskog
- Re: SQL Express - Identity specification property - how to change
  - From: Mike

Prev by Date: SQL Server 2005 article
Next by Date: Re: SQL Express - Identity specification property - how to change
Previous by thread: Re: SQL Express - Identity specification property - how to change
Next by thread: Re: SQL Express - Identity specification property - how to change
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL2005: Running TSQL commands in single-user mode
... KILL to terminate it. ... Kind of difficult when Mike can't connect... ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Using OSQL and DTSRUN
... mike writes: ... from some access tables and pulls them into SQL However these access ... By the way it runs just fine if I run it from the SQL server. ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Query training -- Complex queries
... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
(microsoft.public.sqlserver.server)
Re: Linked Server: How to check if server exists?
... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
(microsoft.public.sqlserver.connect)
Re: STORED PROCEDURE - passing table name as a parameter
... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)