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 - 2000-11-17 : 08:59:34
|
Dariush writes "Hi: I have a Table with two fields: CatID (not a Primary Key) and CatName: I would like to move up/down any row with just one UPDATE. For example, if in row 12, CatID=12 and CatName=A, and in row 13, CatID=13 and CatName=B, is it possible by clicking an update button once to get CatID=12 and CatName=A in row 13 and CatID=13 and CatName=B in row 12?
Many thanks for any help." |
|
|
|
|
|
Move up/down entire row