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 |
|
gee2410
Starting Member
2 Posts |
 Posted - 2007-02-10 : 22:51:34
|
| Is there any way that I can drag and drop rows in SQL Server Studio Management Express? Every time I open a table, I want to move a row by just dragging and dropping but it can't be done. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-11 : 00:34:45
|
quote:
Originally posted by gee2410
Is there any way that I can drag and drop rows in SQL Server Studio Management Express? Every time I open a table, I want to move a row by just dragging and dropping but it can't be done.
move a row? what do you mean? you don't like the order the rows are in or something?-ec |
 |
|
|
gee2410
Starting Member
2 Posts |
Posted - 2007-02-11 : 01:08:27
|
| Yeah. I entered new data and it's out of order. Instead of writing queries or views, I just want to move them manually with the mouse. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-11 : 12:10:57
|
quote:
Originally posted by gee2410
Yeah. I entered new data and it's out of order. Instead of writing queries or views, I just want to move them manually with the mouse.
Just use the ORDER BY keyword in your query. There is no guarantee that data will be returned in a specific order without using ORDER BY.-ec |
|
|
|
|
|
|
Drag and Drop Rows