azuredatastudio
azuredatastudio copied to clipboard
microsoft
Copy Paste Rows in Table Editor
Issue Type: Feature Request
Can't copy and paste a row in editor view. Is there actually no way to copy and paste a row from the table editor? This is one of the most basic features in MSSMS. I hope I am missing something.
Azure Data Studio version: azuredatastudio 1.25.2 (4d4917d328ab7a7526817a0f0ef03237a79aa54d, 2021-01-20T22:52:13.492Z) OS version: Windows_NT x64 10.0.14393
@randallnewman could you please add some descriptions of what you are trying to achieve? maybe some screenshots?
Is it possible to put up screen videos. Will be most effective for me to explain that way.
On Mon, Jan 25, 2021, 2:14 PM Alan Ren [email protected] wrote:
@randallnewman https://github.com/randallnewman could you please add some descriptions of what you are trying to achieve? maybe some screenshots?
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/14034#issuecomment-767048271, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABFN7PZSHHKD5GGOJNI2NM3S3W7KPANCNFSM4WPGAQLA .
@randallnewman yes, but you have to open the issue on github in order to attach files.
See video:
https://user-images.githubusercontent.com/4906943/105862076-66051980-5fbd-11eb-9f33-861cc2af3837.mp4
See video above where I show how I can copy paste in MSSMS but not in Azure
@randallnewman thanks for the video, now it is very clear what you are asking for :) this is the edit data feature. let me assign this to the correct area and let the area owner take a look.
Great. If you find this helpful, I can add more items as I find them.
On Tue, Jan 26, 2021 at 12:40 PM Alan Ren [email protected] wrote:
@randallnewman https://github.com/randallnewman thanks for the video, now it is very clear what you are asking for :) this is the edit data feature. let me assign this to the correct area and let the area owner take a look.
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/14034#issuecomment-767708840, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABFN7PYLRU4EDKMEKOGFCCDS3347TANCNFSM4WPGAQLA .
Is there an update on this? its the only reason I have SSMS still installed on my laptop!
Also, when you copy an item from a cell, the formatting is not maintained (which it is on SSMS) - again another annoying problem that keeps me still having to use SSMS.
For exmaple, say that I have code stored in the DB and I want to copy that to Visual Studio Code, the formatting is lost and its just one long line of code. In SSMS the formatting is maintained so I can copy into VS Code, change something and copy and paste it back. With Data Studio this isnt possible and really frustrating.
I have not heard an update. I am still using SSMS too. I feel like I'm still in Windows 98. Come on MS!
Like in SSMS, when editing data in an existing table, I want to be able to paste multiple rows at once (e.g. from Excel).
Just realized this issue where opened 2 years ago... I really want this feature
I haven't received a response yet - TBH i've had to go back to SSMS, which is a real shame.
On Tue, Jun 6, 2023 at 4:29 PM Jörg Rosenhagen @.***> wrote:
Any Updates on this?
— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/14034#issuecomment-1578987629, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABJ6FVQNXJQEITXZDJFKCLTXJ5EGTANCNFSM4WPGAQLA . You are receiving this because you commented.Message ID: @.***>
@kishanhickman to confirm - if you had this functionality in ADS, then you would be able to do 100% of the work you need in ADS, and not use SSMS again? This is the ONLY thing blocking you? Perfectly fine if so, I just want to make sure I understand priority of functionality based on your use and workflow. Also, this is when you are editing data in a table, correct? Not from the output pane after running query (just want to verify, thanks).
@randallnewman I want to make sure I understand your use case, and I read through the comments so forgive me if I'm repeating information you've already supplied. You are editing data in a table, and then you also want to copy values from the editable cells, and paste them elsewhere, correct? If that is correct, what is the workflow? I'm looking to understand why you copy the data from the edit data window versus from the output window (e.g. run a query and copy from there).
For anyone else (who I did not tag) who has commented or upvoted, please feel free to add another comment with your use scenario/workflow. I understand you want to copy the data, I would like to also understand how you get to this window and why. What are the steps you go through and what problem do you solve with this method? Thank you!
Hello @erinstellato-ms , in our case it is about simply copying a line in edit mode and pasting it directly again. So, it can be duplicated (if necessary, without the self-counting Id, which is assigned automatically) and then edited again before the data is sent to the SQL.
The use case is just for people who can't write SQL statements and then only "just" want to change something directly in the table.
Hi Erin,
Yes that is main sticking point that prevents from using ADS
Best Regards,
Kishan Hickman
On Wed, Jun 7, 2023 at 4:57 AM Erin Stellato @.***> wrote:
@kishanhickman https://github.com/kishanhickman to confirm - if you had this functionality in ADS, then you would be able to do 100% of the work you need in ADS, and not use SSMS again? This is the ONLY thing blocking you? Perfectly fine if so, I just want to make sure I understand priority of functionality based on your use and workflow. Also, this is when you are editing data in a table, correct? Not from the output pane after running query (just want to verify, thanks).
@randallnewman https://github.com/randallnewman I want to make sure I understand your use case, and I read through the comments so forgive me if I'm repeating information you've already supplied. You are editing data in a table, and then you also want to copy values from the editable cells, and paste them elsewhere, correct? If that is correct, what is the workflow? I'm looking to understand why you copy the data from the edit data window versus from the output window (e.g. run a query and copy from there).
For anyone else (who I did not tag) who has commented or upvoted, please feel free to add another comment with your use scenario/workflow. I understand you want to copy the data, I would like to also understand how you get to this window and why. What are the steps you go through and what problem do you solve with this method? Thank you!
— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/14034#issuecomment-1579840596, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABJ6FVVVX3XOJNPD26E64KLXJ7335ANCNFSM4WPGAQLA . You are receiving this because you were mentioned.Message ID: @.***>
Hello @erinstellato-ms , in our case it is about simply copying a line in edit mode and pasting it directly again. So, it can be duplicated (if necessary, without the self-counting Id, which is assigned automatically) and then edited again before the data is sent to the SQL.
The use case is just for people who can't write SQL statements and then only "just" want to change something directly in the table.
Thank you for providing that additional detail @joergrosenhagen, that's very helpful. And for those users who do not write T-SQL statements, is ADS a more preferable tool overall for them? My assumption (possibly incorrect) is that they are not DBAs, even though they have access to modify data. Correct? I would like to understand more about what those users need to do in a tool like ADS or SSMS. I really appreciate your reply and help here!
And for those users who do not write T-SQL statements, is ADS a more preferable tool overall for them?
ADS is faster and more lightweight, so yes.
My assumption (possibly incorrect) is that they are not DBAs, even though they have access to modify data. Correct?
This is correct. I am also aware that this should not be the way how someone changes or adds data, but it just works in SSMS and is so wished.
I would like to understand more about what those users need to do in a tool like ADS or SSMS. I really appreciate your reply and help here!
I am happy that I can help
I'm a software developer and I create database tables for the development phase of an app. I use C# for the app and am using LINQ so I don't write T-SQL statements.
Copy/Paste would be wonderful so I can use ADS exclusively.
The only other thing that I sometimes do is create views. The graphical view creation in SSMS is nice and I don't see that in ADS. But I could Script As Create an existing view in ADS and modify and execute the SQL to create a view that way. This functionality is probably a bigger task than the copy/paste and I don't do this often.
Hi @kkarasti - thank you for sharing your use case and the experience of using LINQ and not writing many T-SQL statements. When you use Copy/Paste, is it because you are populating just a bit of data into the table (e.g. a few rows, not thousands of rows)? I want to understand the number of rows (volume of data) you might be copying and pasting in this scenario. Thus far, folks have mentioned one row at a time. Is that your scenario, or do you need/want to copy more rows (and how many)?
I understand creating views, and you are correct in that the view designer does not exist in ADS. We haven't seen quite the same demand for that as table designer, so it is lower on our list. Your option to script out an existing view and then modify it is a good workaround for the time being. To upvote the existing issue for a view designer, please see: https://github.com/microsoft/azuredatastudio/issues/7310
Thanks!
Correct, just a bit of data. Usually the tables that I'm using are storing configuration data that I only read from. So I may want to add a duplicate record to see how my app handles that situation. Or a duplicate record and then modify one small part of it.
So yes, that is my scenario also, just one row at a time.
This feature will help me copy/paste data between tables that have the same columns. It will also help me copy data from a spreadsheet and paste to insert into a table.
ADS has so many amazing features how come it missed this one!! I'm really looking forward to have this feature on ADS.
Proposed Solution
-
Support new context menu option on existing rows to Copy or use Keyboard Shortcut (Ctrl + C):
-
Support new context menu option on empty row to Paste or use Keyboard Shortcut (Ctrl + V)
cc @erinstellato-ms
Proposed Solution
- Support new context menu option on existing rows to Copy or use Keyboard Shortcut (Ctrl + C):
- Support new context menu option on empty row to Paste or use Keyboard Shortcut (Ctrl + V)
cc @erinstellato-ms
I completely agree with you.
2024-1-18 : Unable to Copy / Paste rows in the editor yet ? We can Copy a row from a Result Set but not paste it in the editor right now. This is the most useful thing in SSMS
Version: 1.47.1 (user setup) Commit: b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e Date: 2024-01-10T02:15:02.628Z VS Code: 1.82.0 Electron: 25.8.4 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.22621
Bumping this issue. Even Visual Studio SQL Server Object Explorer supports pasting whole tables.
