Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting Record Numbers 1

Status
Not open for further replies.
grayt26

grayt26

Technical User
Jun 2, 2006
26
GB
Hi all,
I have a table and i need to insert a field which contains the row number of that record. I know this is possible in FoxPro but in SQL I have no idea.

Thanks for reading.
 
Sort by date Sort by votes
what u require is an IDENTITY columnn...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
thanks for that, most useful

Cheers
 
Upvote 0 Downvote
wc...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

scubafrog79
  • Locked
  • Question
Flag record if there two different locations for that record in another table 1
Replies
3
Views
235
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
531
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
341
Andrzejek
Andrzejek
Lidias13
  • Locked
  • Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
285
ggriffit
ggriffit
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
628
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top