MS SQL

MS SQL RSS

How to add an index column whose values you can retrieve

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Aug 2009

Posts: 4

Reputation: Smirgu is an unknown quantity at this point

Solved Threads: 0

Smirgu

Offline

Newbie Poster

How to add an index column whose values you can retrieve

Aug 5th, 2009

I would like to add a column to an existing table, where the new column would only have running numbers starting from 1. If I've understood correctly, the "create index" command is not the right way to do this, as that's attached to just certain columns to speed up querying.

The reason why I want this is that after exporting the data from the database I would still need to know the order of the rows.

Last edited by Smirgu; Aug 5th, 2009 at 6:27 am.

•

Join Date: Feb 2009

Posts: 3,214

Reputation: sknake has much to be proud of

Solved Threads: 572

sknake

Offline

.NET Enthusiast

Re: How to add an index column whose values you can retrieve

Aug 5th, 2009

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE TestTable
(
  SomeInt INT,
  SomeString VARCHAR(10)
)
 
GO
--This adds an auto number column
ALTER TABLE TestTable Add RowNumber INT identity(1, 1)
Create Table TestTable
(
  SomeInt int,
  SomeString varchar(10)
)

GO
--This adds an auto number column
Alter Table TestTable Add RowNumber int identity(1, 1)

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Aug 2009

Posts: 4

Reputation: Smirgu is an unknown quantity at this point

Solved Threads: 0

Smirgu

Offline

Newbie Poster

Re: How to add an index column whose values you can retrieve

Aug 5th, 2009

•

Originally Posted by sknake

Help with Code Tags

sql Syntax (Toggle Plain Text)
CREATE TABLE TestTable
(
  SomeInt INT,
  SomeString VARCHAR(10)
)
 
GO
--This adds an auto number column
ALTER TABLE TestTable Add RowNumber INT identity(1, 1)
Create Table TestTable ( SomeInt int, SomeString varchar(10) ) GO --This adds an auto number column Alter Table TestTable Add RowNumber int identity(1, 1)