Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-20 : 09:48:25
|
| Rebecca writes "Hi,I have an SQL question. Is it possible to update a value in a row according to a row number? (I can't have a row_number column.)Thanks,Rebecca" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-03-20 : 09:54:54
|
| SQL tables don't support the concept of row numbers. The data is just stored - in no particular order. Updating/selection of records can only be achieved based on data being delibrately sorted into a particular manner.This has been mentioned before in this site. There may be other articles with more comprehensive explainations available through the 'search' facility |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-20 : 14:05:48
|
| I'm thinking that updating a single row would best occur based on a PRIMARY KEY. You DO have a Primary Key for your table, don't you?------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Updating table by row number